By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Dim As Database

P: n/a
gn
In access 97 I could Dim As Database. Access 2002 doesn't have that
option : ( What do I do instead?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 19 May 2004 21:24:00 -0500, gn <gn@hotmail.com> wrote:
In access 97 I could Dim As Database. Access 2002 doesn't have that
option : ( What do I do instead?


You need to set a reference to the DAO 3.6 library
By default Access 2000 uses ADO and does not have a reference to DAO set in a new db.

Open any standard module and on the Tools menu, select References. If you are not going to use ADO, uncheck the Active X
Data Objects (ADO) reference and select the DAO 3.6 option instead.

If you are going to use ADO and also want to use DAO, select both options but you must then explicitely declare the
library when you set objects as both libraries contain objects with the same name eg Recordset -
Dim rst as DAO.Recordset
Dim rst as ADO.Recordset
Wayne Gillespie
Gosford NSW Australia
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.