Simple DB open

[Paul Wagner]

I copied over tables, forms, reports, etc from another older database into a conversion database.

A module that uses this construct in the old database...

Dim db As Database
Set db = CurrentDb

...generates "User type not defined" in the new database. Why?

Thanks, Paul

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?t=61060

 

[Paul Wagner]

Rich:

Thanks for the nice explanation. I get it now. I think I'll use the "disambiguate" method as I have other code elsewhere on the system that I believe still uses ADO.

Again, thanks.
Paul