DAO ignorance...

[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

 

[Rick Brandt]

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?

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.