April 9, 2024
Contribute to the Microsoft 365 and Office forum!
Click here to learn more 💡
May 10, 2024
Access Forum Top Contributors:
Compile error - user defined type not defined, on Dim dbs as Database
Report abuse
Thank you.
Reported content has been submitted
Make sure the Data Access Objects library (DAO) is checked in the Tools - References list in the VBA Editor's menu/ribbon. (The specific name of the library can be different in different versions of Access)
Also look at the ActiveX Data Objects library (ADO) in the list and if you do not have a good reason for using it, uncheck it so it doesn't weigh your app down with unused stuff. If you do have a good reason for using both libraries, then you should declare objects that exist in both libraries with their library name:
Dim rs As DAO.recordset
or
Dim rs As ADODB.Recordset
depending on which one you are using in in a procedure.
The Database object only exists in the DAO library, so it is not absolutely necessary to qualify it in declarations, but it's a good idea if for no other reason than as a reminder of which library it is in.
Report abuse
Thank you.
Reported content has been submitted
42 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Try....
Dim dbs as DAO.Database
Also, you'll want to check your References...
http://www.access-diva.com/d5.html
...as there might be one that is marked *MISSING*.
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html
Report abuse
Thank you.
Reported content has been submitted
21 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated May 11, 2024 Views 55,381 Applies to: