I must be missing something simple. I try to use the statement 'Dim db as Database' and the system tells me that the user defined type not defined. I have the same exact line in another piece of code in another database and it works fine. Any thoughts. I am running Access 2002 on XP professional. I have not written code for this in about 3 years and was thinking that some of the definitions may have changed.

Thanks Eric

I think you need to add a reference to Microsoft DAO object library. I use the 3.6 one in my app.

I think hashlishnii is right on that one.
The default for Access 97 was to use DAO, from Access 2000 onwards, the default is ADO.

I am a loud man with a very large hat. This means I am in charge