Dim db As DAO.database - says user-defined type not defined?

[CazB]

I have an 'old' database that was originally set up in Access 2003 and I've had to leave it that way as we still have a couple of users who are using 2003 (I'm on 2007...)

Don't know if that's the problem but when I just tried putting Dim db As DAO.database into my module code in a form event procedure, and then go to compile, it says user-defined type not defined

Help?? I'm a self-taught dabbler so stuff like this bamboozles me!

 

[pbaldy]

In the VBA editor, go into Tools/References and check the MS DAO reference.

 

[CazB]

Thanks - so easy and quick to fix when you know how!!

 

[pbaldy]

No problem!