VBA Compile Error

[ninfan]

Hello all. I have copied an Access2000 DB from one machine to another and I'm now getting a compile error on one of my modules. Here's the offending line:

Dim db As Database

The error tells me "user-defined type not defined".

It would seem to me that I am missing a VB DLL or something similar but I'm not sure where to start looking. Any ideas would be greatly appreciated! Thank you!

 

[Databaseguy]

Either set the references to DAO3.6 or change the code to be ADO complient. Ex:

Was (97)

Dim dbs as database
Set dbs = currentdb()

Is (2000)
Dim cnn as ADODB.Connection
Set cnn = CurrentProject.Connection