Hale, Jim
Jim.Hale at FleetPride.com
Wed Jul 27 12:46:18 CDT 2005
If you are basically selecting data for reporting you might switch to pass through queries. This has worked well for me. Jim Hale -----Original Message----- From: Paul M. Jones [mailto:pjones at btl.net] Sent: Wednesday, July 27, 2005 12:14 PM 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 *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.