DAO ignorance...

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hello,
I'm trying to put together an Access2000 Database. I
needed a certain function and someone was nice enough to
write a vb script for me. Trouble is, it has the line

Dim db As DAO.database

turns out I don't have DAO so this doesnt work. Finally,
my questions. Is DAO something I have to buy? or are there
free versions out there? Once I get it, I just install it
and everything runs fine?

Thanks a bunch,
Dan
 
Dan said:
Hello,
I'm trying to put together an Access2000 Database. I
needed a certain function and someone was nice enough to
write a vb script for me. Trouble is, it has the line

Dim db As DAO.database

turns out I don't have DAO so this doesnt work. Finally,
my questions. Is DAO something I have to buy? or are there
free versions out there? Once I get it, I just install it
and everything runs fine?
Click to expand...

You have DAO, it's just that Access 2000 doesn't use it by default. Open a
code window and then go to Tools - References on the main menu. When the
references dialog comes up scan down until you find the Microsoft DAO 3.6
library (or similar). Check the CheckBox next to that and the code should
start working.
 
Back
Top