Microsoft KB Archive/95054

From BetaArchive Wiki

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
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.