Compiler error at "ConnectDb"

[Peter]

Hi,

my Access97 gives me in a VBA program an compiler error at
the command "ConnectDB". The Error message is talking
about wrong function interface (of ConnectDB, I think).
I have installed and activated DAO 3.6. Without DAO a
error about missing data types occures.

On other maschines the program works well. Also with
Access 2000.
I think a special file (may be an DLL) is missing.

Can anybody help me?

Best regards
Peter

 

[Dirk Goldgar]

Hi,

my Access97 gives me in a VBA program an compiler error at
the command "ConnectDB". The Error message is talking
about wrong function interface (of ConnectDB, I think).
I have installed and activated DAO 3.6. Without DAO a
error about missing data types occures.

On other maschines the program works well. Also with
Access 2000.
I think a special file (may be an DLL) is missing.

Can anybody help me?

I have no idea what "ConnectDB" might be. As far as I know, it's not a
keyword in Access 97 or Access 2000, not in DAO. Were you thinking of
"CurrentDb", or is "ConnectDB" a user-defined function?

You'd better show your VBA code.