[AccessD] Connecting MS Access 2000 to SQL Server 2000

Jim Lawrence accessd at shaw.ca
Wed Jul 27 20:49:48 CDT 2005


Hi Paul:

By using ADO-OLE. There are many references and code that have been on it
posted on the list over the years. Just go to site/page
(http://www.databaseadvisors.com/archive/archive.htm ) on the DBA site and
search on ADO.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul M. Jones
Sent: Wednesday, July 27, 2005 10:14 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Connecting MS Access 2000 to SQL Server 2000

I have an application initially written in Access 97 and then moved to 
2000.  It talks to a SQL Server 2000 database using tables linked through 
an ODBC driver.  Lately I have had several instances where I call a stored 
procedure to perform an operation but I don't receive a response from the 
SQL Server even though the operation was carried out successfully.  This 
leaves my application hanging.  I suspect it has to do with the ODBC 
connection.  Anybody has any experiences with this type of issue?

On a related note, is there a better way of linking my tables to the SQL 
Server other than to use an ODBC driver?  I have a couple of newer projects 
that use ADP but unfortunately, it's not an option for me at this point 
since I have too many queries that I'll need to convert to either stored 
procedures or views.

Thanks

Paul M. Jones


----------------------------------------------------------------------------
------------------
Reality is the murder of a beautiful theory by a gang of ugly facts.
         Robert L. Glass 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list