Hello

Using MS Access 2000, when I open the famous Northwind sample
database, the data type "Database" is available in Visual Basic code
modules.

However, when I create my own, new database(s), the data type
"Database" (and a few other built-in Types) is not available in VB.
Most built-in Types, however, are available (eg. "Recordset").

I assume it is a product configuration/setup issue, though the fact
that everything is available when I write code in Northwind is
surprising.

Any suggestions much appreciated.

Regards
Mark

Check your references. In the code editor go to tools->references. You
should have "Microsoft DA0 3.x Object Library". Not sure if this is
it, but it's worth a try.

Mark wrote:
--
-[ Andrew Backer / abacker .@. comcast .dot. net ]-

Also, if you want the DAO objects as distinct from the ADO objects to be
visible by default, ensure your reference list (see Andrew's post below)
places DAO higher than ADO.
HTH
Doug

Andrew Backer wrote: