[AccessD] Declaring Database

Keith,

Which data access method are you using?  DAO or ADO?  In A97 and
earlier, DAO is the default data access method.  In A2K and later, ADO
is the default.  You need to explicitly type your database as either DAO
or ADODB if you have both referenced.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us
(SELECT * FROM users WHERE clue > 0)


-----Original Message-----
From: Keith Williamson [mailto:kwilliam at ashlandnet.com] 
Sent: Tuesday 2003 Feb 18 11:13
To: accessd at databaseadvisors.com
Subject: [AccessD] Declaring Database

Can anyone shed some light on why my Access 97 would be having a problem
with a "Dim dbs as database" declaration?

I was using the Switchboard Manager utility to setup menus on my
application.  In the process of this, the utility wizard created code
which included the above declaration.  However, the application keeps
giving me an error on that line, saying the variable isn't defined.
Isn't that what the declaration is doing???...defining the variable??
Can't imagine what the problem is.  Anyone with any ideas?  I've used
the wizard a number of times to setup menus.  Never had this problem
before.

Thanks in advance,


Keith E. Williamson
Ashland Equipment, Inc
phone # (410) 273-1856
fax #     (410) 273-1859