strange mssql error
Fri, 22 Aug 2008 23:51:54 +0200
Hi
I'm a C# developer and I have very strange problem while using mssql INSERT
statement.
I've received an error like:"System.Data.SqlClient.SqlException: The
statement or function must be executed in the context of a user transaction.
The statement has been terminated."
Can anyone help me with this ?
S ...
|
HELP me! How to update table in sql server from access form
Thu, 21 Aug 2008 19:51:47 GMT
Hi,
I have upsizing access to sql server. I have three big tables that's heavily
updated daily by users. I have upsized these 3 tables to sql server 2005.
(I'm using Access 2003).
I'm using a form call "CollectorDashboard" to update these 3 tables. User
will type in values in the text boxes and click "updat ...
|
Using Access 2007 adp project files with SQL Server 2008 Express
Thu, 21 Aug 2008 07:04:01 -0700
I am trying to work my way through Access 2007 Inside Out. On page 133 the
book instructs me to download and install SQL Server 2005 Express from
www.microsoft.com/sql/editions/express/default.mspx and I could only find SQL
Server 2008 Express. I installed SQL Server 2008 Express and when I tried to
open t ...
|
Write conflict Error message
Wed, 20 Aug 2008 15:00:01 GMT
Hi,
I am getting the write conflict error message some times but not always.
Its ADP project and back end is sql server 2005 express edition. when ever I
try to enter new record using forms i get this error some times.
I did put timestamp clolumn on the table ,bit field is having default value
as 0 and it i ...
|
Work with Access adp as frontend on distance
Tue, 19 Aug 2008 23:14:17 -0700 (PDT)
Hi everyone.
I have this problem:
I have a rather large Access2003 application (adp) that uses a
sqlserver database in the network at my work.
Now I want some users to work with this applicatoin from distance
through the internet.
I have experienced that it works fine to connect from an Access-adp
project ...
|
Testnachricht
Wed, 20 Aug 2008 01:35:13 +0200
Hallo,
ist die Nachricht angekommen.
...
|
SERVER FILTER Form Property
Tue, 19 Aug 2008 12:51:01 -0700
I have an adp form (Form A) tied to SLL Server. Users normally select the
form from a different form (Form B) that lets them select a record's control
number, click a control button (DoCmd.Open Form... ) and Form A opens to the
correct record.
Sometimes, the Form A opens to the same record, regardless of wh ...
|
|
|
Form filter help with .adp with Access 2003 Runtime
Fri, 15 Aug 2008 13:42:07 -0700
I have up and running an access data project (.adp) with SQL Server 2000.
I'm looking for some help with filter by form and/or filter for:________
functionality on the forms. Seems that form filtering with .adp and Access
runtime is not fully workable.
I want my users to be able to open forms and be able ...
|
Syntax when setting ado rs or conn timeout (not adp)
Thu, 14 Aug 2008 22:00:23 -0700
I'm trying to use ado to test connectivity with a sql server, and would
like the timeout value to be pretty short (5 seconds or so). But I can't
find the right way to set the timeout value. All of my tests fail after
30 seconds or so if the sql server is stopped. Access 2003 mdb.
Public Function GetUserIDFr ...
|
SQL Express Login Prompt From Access 2007 ADP
Tue, 12 Aug 2008 14:02:11 -0700
First off, I'm using Access 2007 SP1, and SQL Server 2005 Express, on my
local computer before I roll it out to the client.
I have converted my Access 2000 database to Access 2007 and data table held
in SQL express.
Where I need help or guidance with is when I start the Access 2007 adp, I
keep getting ...
|
