By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,686 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,686 IT Pros & Developers. It's quick & easy.

Opening Access table in VBA

P: 1
I have tried acces a MS Access table using the code listed below but i get teh message "User-defiend type not defined"
Dim db As DAO.Database
Apr 29 '10 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
My guess would be that you don't have Microsoft DAO 3.6 Object Library loaded in your references.

Go into the code module for a form and goto Tools - References and see if this is checked. If not, check it and exits and see what happens.

Welcome to Bytes!

Linq ;0)>
Apr 29 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.