ACC1x: Driver Cannot Be Found When Attaching to SQL Server |
Q95054
The information in this article applies to:
- Microsoft Access versions 1.0, 1.1
SYMPTOMS
When trying to attach a SQL Server table, or open a previously attached table, you receive the following error message:
Driver specified by data source could not be loaded.
CAUSE
The most likely cause of this error message is a missing, damaged, or incorrect version of the SQLSRVR.DLL file.
Other situations may indirectly cause this error message. For more information, query on the following words here in the Microsoft Knowledge Base:
debugging and troubleshooting and tips and Q102437
RESOLUTION
To correct this problem, verify the following:
- There is a single copy of the SQLSRVR.DLL file in your Windows SYSTEM subdirectory.
- You have the correct version of the SQLSRVR.DLL file. The version installed by Microsoft Access version 1.0 is dated 10-16-92 and has a size of 135792 bytes. You need either this file or a more recent version.
Additional query words: kbtshoot tshoot
Keywords : kberrmsg kbusage
Issue type : kbprb
Technology :
Last Reviewed: November 4, 2000 |