New to VBA and cant use Dim db as Database

[newboy18]

I am reading through a VBA book and it asks me to type:
Dim bd as Database
Dim rec as Recordset
As I type I get popups for recordset but not for Database, If I try to run the code it gives me an error "User-defined thpe not defined.
The book comes with examples that include these basic statments and they are OK. I am stuck and dont know why this is happening, would someone please shed some light.

 

[SgtJarrow]

Assumption....You are using Access 2000 or Access XP

Solution: Access 2000/XP uses ADO, instead of DAO and therefore Database is not a declared type....

in your code, use:

Dim db As DAO.Database
Dim rst as DAO.recordset

And also make sure you have the Microsoft 3.51 DAO objects checked as a reference in your reference list. If we knew what it was we were doing, it would not be called research, would it? - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[danvlas]

Try:
Dim db As DAO.Database
Dim rs As DAO.Recordset

If no result, open any module, go to Tools-References and check Microsoft DAO 3.6. Object Library

That should solve the problem.
It seems your VBA book is older than the VBA version you use.

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[newboy18]

Thanks fo that, it looks like I just wasted £30