Compile Error - Failure to load Dll

[DemonHub]

Hi,

Hope someone can help with this problem.

I open a database on my PC and it's opening perfectly but when I try to open the same database on an other PC I got a compile error.

We have both Win98SE and MS Access 2002 and both the same VBA version.

The file format is Access 2000.

I've try to copie my DLL in my folder...
C:/Program Files/Fichier Communs/Microsoft Shared/VBA/VBA6
... And copy it in her same folder but no result.

Her VBA can't compile the vba code that I have in the Database

Here the line where the error.

Set cn = CurrentProject.Connection

The word Connection is highlited and a message box that say

Compile Error
Failure to load the DLL

But the name of the DLL is not on the message box.
We really don't know what to do and the Micosoft Help do not help , the only thing useful is the number of the error (48).

We'll try to copie all my windows .dll on is computer but It's may not work.

 

[KenHigg]

Have you checked the 'References'?

 

[DemonHub]

Yes and we have the same reference

 

[KenHigg]

Have you tried to do just a simple down and dirty .mdb that only attempts the connection?

 

[DemonHub]

Nope but it's not the Connection line the problem , It's the compilater who's not able to compile my code forms.

 

[KenHigg]

Hum... So what about if you make a new .mdb and import all the objects over?

 

[DemonHub]

The database is working great and it's shared on a local network , when I open it on my pc it's ok but on the other pc it can't compile the code.

There missing a DLL or something like that.

So there's no need to recreate the .mdb

 

[KenHigg]

Sounds like you're making your way towards a re-slick

 

[DemonHub]

Can it be a problem with the .Net Framework?

 

[JohnD]

Compile Error
Can't find Object or Library

Im getting the error as well. Works on my station, but others it does not. (cpu's have same setup)


John