"Dim WHATEVER as database" not working in 2010

[Gingertrees]

OK, I'm no expert in any form of VBA, but I know there were changes from VBA circa 2003 to the VBA used in Office 2010.

There are two routines I've tried to copy into Access 2010 modules that have errored at this point:

Dim whatever as Database
'database not defined

what has Database become in this new version?

 

[boblarson]

It still works but you have to have the DAO reference checked (which in 2010 would be the Microsoft Office Access Database Engine Object Library). If you are using the old mdb format you would need the Microsoft DAO 3.x reference instead.

Also, I usually make it more explicit -

Dim whatever As DAO.Database

 

[Gingertrees]

Ah, didn't know about that - thanks Bob! Activating the DAO 3.6, then rewriting as you suggested worked