error loading dll in Access 2000

[benedetto]

 
Dear friends,
I must write a new module in Access to change the library ADO with DAO3.6.
When I try to do it the Microsoft Visual Basic display this message:"Error loading dll" .
I have already re-installed all the office-package but the risult is the same.
Thanks a lot for your help.
Regards
Benedetto

[Sidewinder]

I must write a new module in Access to change the library ADO with DAO3.6.

Are you refering to the VB references? Once you bring up the module screen, click Tools-->References and then click Microsoft DAO 3.6 Object Library. Be sure to unclick Microsoft ActiveX Data Objects 2.1 Library.

If I misinterpreted your question, repost and maybe we can go from there.

[benedetto]

Yes, I had already done all many times, according to your instructions .
When I click to "OK" the system doesn't create the module and the message is , as I wrote, "error loading dll"(my computer speaks italian and swedish but the translation is correct, I think).
Thank you very much for your help.
Benedetto

[Sidewinder]

Perhaps the DAO360.dll is not properly registered. Generally the DAO360.dll can be found in c:\Program Files\Common Files\Microsoft Shared\dao

Try registering the dll:

Code: [Select]


Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao360.dll


You may have to change the path to your situation. Note: do not use the long file name when running regsvr32. Use the old fashioned 8.3 notation.

Hope this helps.

[benedetto]

Dear Sidewinder,
thank you very much for your answer.
I found the dao360 in microsoft shared\DAO but the extension is .chm, not .dll.
Is this the problem?
I tried also to register the dll as you wrote in your message but I didn't succeed.
Many thanks if you can suggest any other solution.
Benedetto

[Sidewinder]

Try doing a Windows search for DAO360.dll on your disk(s). If and when you find it, use the path (the 8.3 version of the path) to run regsvr32.

If the DAO 3.6 showed in the Access VB reference window, it should be on your system somewhere. The Microsoft Shared\DAO folder should hold all the versions of DAO. A CHM file is a compiled help file and should not be in the DAO folder but in the Office documentation folder.

When Office was installed did you experience any problems? Just out of curiousity why DAO and not ADO?

[benedetto]

Dear Sidewinder,
thank you for your help.
I fixed all.
I must change ADO with DAO because an italian access-microsoft expert suggested it to improve my database,he said that ADO is no longer in use.
Anyway have a Merry Christmas if I don't post anything more today.
Benedetto