Type-not defined error after conversion.

[mafhobb]

Hi.

I have converted a 2003 database to 2007 and I have run into the error shown attached.

The 2003 database has been in use for a long time without problems, it was NOT split and it was using user-level security. I removed the user-level security , imported it into access 2010 and then saved it as an accdb file. It seems to work fine except for the error mentioned "Compile error: User-defined Type not defined"

Suggestions?

Thanks

mafhobb

 

[JANR]

ADO is no longer default in access 2010 but DAO is so you are missing a refrence to this library.

under Tools -> Refrences

Locate your missing ADO library.

JR

 

[mafhobb]

I see. Do you know if there is a page I can go to figure out what has changed between 2003 and 2010?

mafhobb