HI
I have inherited the maintenance of an access2000 application which in production links to sql server 2000 tables.
The code snip below works fine on sql server 2000 using ODBC but fails when i run on server 2005 on my own machine.
Help very much appreciated!!
On Error GoTo ErrHandler
Dim strConnSPDB As String
Dim errLoop As ADODB.Error
Dim strError As...
mbsparrow
Last Activity: Nov 13 '07, 08:35 PM
Joined: Nov 18 '06
Location:
-
Running access 2000 ap on sql 2005 express edition
-
Thanks it worked. Saved me hours of head banging... -
Can't Connect to Database Engine
I have just installed sql server 2005 Express . The Server is running but I can't connect to the Server in Server Management Studio (on the same machine). I am getting the following message:
TITLE: Connect to Database Engine
------------------------------
Cannot connect to MARION\SQLEXPRE SS.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while... -
Error on Execute in access application
Hi
This code is part of an application currently running in production which I must perform maintenance on. On my PC it throwing an error after the execute command. My Odbc connection is working fine and connecting to the db.
The error message says that "The connection cannot be used to perform this type of operation it is either closed or can not be used in this context"
Code must be ok so whats amiss
... -
Many ThanksLeave a comment:
-
MS access on a network
I have inherited an ms access application for maintenance work, I have only coded cobol mainframe previously. The Access application is linked to tables on sql server with ODBC. Can several users access the one ms access application on the network or must each workstation be installed with the app.
Thanks
No activity results to display
Leave a comment: