Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reference Paths -- How to Change 1

Status
Not open for further replies.

raskew

Programmer
Oct 18, 2000
488
Can anyone tell me where the paths to references (Access 97) are stored, and how one goes about changing them.

I downloaded an Access 97 application for evaluation. After viewing the application, determined it wasn't what I was after and seeing no uninstall utility, deleted the application and directory from my harddrive. Shortly thereafter, starting receiving error message with other Access 97 applications and, upon checking the references, discovered that the DAO 3.51 Object Library references in all databases now points to: a directory installed by the downloaded application.
.
Clearing the reference just makes it go away, i.e., no reference to DAO 3.51 Object Library exists when I reopen the application. I've deduced that the setup procedure reset the reference for DAO350.DLL from 'c:\program files\common files\microsoft shared\DAO\dao350.dll to the installed directory. Using VBA code to set a new reference works, creating a reference to 3.51 Object Library, but upon opening the references, the same unwanted path appears.

The installed directory has been entirely deleted and the recycle bin emptied.

Have scoured help files, past postings, MS KB, etc., and am still at a loss. Suspect I might be dealing with a registry problem, but can't find an erroneous entry in the registry pointing to the now non-existent directory.

Has anyone successfully resolved a similar situation?
 
You can likely fix the problem by registering the DLL's. The basic command is

Regsvr32 c:\progra~1\common~1\micros~1\dao\dao350.dll

Read more about registering the DAO components in the article "ACC: Microsoft Access Can't Start the Data Access Object" at


Although the article addresses a different problem, it is similar enough to suggest the suggested fix will work for you. The article also lists all of the DLL's you will need to register. Terry

X-) "I don't have a solution, but I admire your problem."
 
Terry-

Yes!!! That did the trick exactly as advertised. Thanks so much.

Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top