Database type

G

Guest

In my Access 2000, I don't find Database type when I write
VBA as:

Dim db As Database

A runtime type error is seen.

Why ?
 
R

RobFMS

The default for a new Access 2000 database is the ADO object module.
If you wish to use the DAO object module:

1. Open up a code module
2. Go to Tools->References
3. Find Microsoft DAO 3.x Object Library.

At this point you can do:

Dim dbs as DAO.Database

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Top