Compiler error at "ConnectDb"

  • Thread starter Thread starter Peter
  • Start date Start date
P

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
 
Peter said:
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?
Click to expand...

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.
 
Back
Top