Access 2003 with SQL Server 2005
Wed, 7 Nov 2007 07:05:00 -0800
I have converted and mdb to an adp using the upsizing wizard. There were
multiple problems with queries being converted. If I try to edit a query or
use design view on a table I get messages saying 2003 is not compatible with
SQL 2005 and no changes will be saved.
I tried creating a query in SQL, but then t ...
|
Trap ODBC errors for bound forms
Fri, 26 Oct 2007 14:49:31 -0400
I have found tons of references for trapping errors (and they all use
essentially the same code) but nothing seems to work for a bound form. I
have tried a variety of events. The error seems to be trapped by the form
level Error event but the error collection doesn't contain a description of
the error that ...
|
Access 2003 / SQL 2005 Express low tollerance for poor network?
Wed, 17 Oct 2007 05:32:35 -0700
I recently converted an application that uses Access 2003 for Frontend
and Backend to Access 2003 FE / SQL 2005 Express BE. The tables are
linked with a DSN-less connection via SQL Native Client.
Several Customers use this application and some of them reported a
dramatic increase in connectivity related errors ...
|
"Dynamic cursors not supported by ODBC driver" Error for dynaset recordsets
Wed, 17 Oct 2007 02:14:36 +0530
Platform: Window 2003 Server Enterprise Edition, VC 2005 , ODBC version
3.52, MDAC 2.8, MSAccess2000 database
Hello
In our multithreaded VC++ application, we are accessing certain tables using
CRecordset (with dynaset properties set)
We are facing ODBC related error (for MS ACCESS database) i.e. "Dynam ...
|
ODBC mysql-access slow
Wed, 10 Oct 2007 09:54:52 +0200
I have a data base Access that links to another mysql by
mysql-connector-odbc-3.51.12. If I execute a query by odbc to a table with
1000 records this query takes between 5 and 6 minutes, whereas if I directly
execute it in server it takes less of a second. what I can do so that it is
executed but fast?
...
|
user id information for logging
Sat, 29 Sep 2007 01:13:00 -0700
I know how to get Windows authentication in .NET... how do you access this
information using ADO (not ado.net)
I want to retrieve user information to log transactions within my
application which is an ADP ...
|
ODBC connect error SQL-HY000
Wed, 26 Sep 2007 12:25:01 -0700
I am calling a perl scrip from my Access database. The perl in turn connects
to the database to write to some of the tables. I get a message that says,
"The database has been placed in a state by an unknown user that prevents it
from being opened or locked."
Does anyone know how I need to set up the databa ...
|
|
|
Record changes on a bound form after saving the record
Wed, 26 Sep 2007 14:16:23 +0100
I have an Access 2007 FE database that links to a SQL server 2005 with ODBC
linked tables.For most of the time the database works fine but every so
often things go screwy in one form.
The form uses a filtered record set in a continuous form view and allows the
user to add and edit the records. This will be ...
|
ODBC Refresh Interval
Tue, 25 Sep 2007 18:15:20 GMT
We are using SQL Server as a back end to an Access front end on a LAN using
ODBC linked tables. Users are periodically getting the "data has been
changed by another user" error, and it's causing them to have to re-enter a
lot of data.
The ODBC refresh interval has been left at the default (1500 sec) on all ...
|
odbc timeout using begintrans on linked sql server tables
Tue, 25 Sep 2007 00:32:03 -0700
Hi,
I have two different Access 2003 applications, they both have linked
tables to the same SQL Server 2005 database.
Since my applications often have to perform several related inserts,
updates, I prefer using transactions.
After carefully reading Microsoft sites and Google discussions, I
decided to use the ...
|
