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

Dim problem

P: n/a
Dear group, here is my problem

In the code of a form, i want to declare a variable :

Dim Base_Photo as Database, But Access 2000 don't propose
"Database" and don't accept it.

But, in an other Base, with Access 2000, this is possible and
accepted and works !

I did not find the différence, could you help me ?

Thank You
--
_________________________________

Site photo personnel :

http://perso.wanadoo.fr/dimphoto
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
From the code window, choose References on the Tools menu.
Select the box beside:
Microsoft DAO 3.6 Library.

More info:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Alain." <_@wanadoo.fr> wrote in message
news:bk**********@news-reader3.wanadoo.fr...
Dear group, here is my problem

In the code of a form, i want to declare a variable :

Dim Base_Photo as Database, But Access 2000 don't propose
"Database" and don't accept it.

But, in an other Base, with Access 2000, this is possible and
accepted and works !

I did not find the différence, could you help me ?

Thank You
--
_________________________________

Site photo personnel :

http://perso.wanadoo.fr/dimphoto

Nov 12 '05 #2

P: n/a
"Alain." <_@wanadoo.fr> wrote in message news:<bk**********@news-reader3.wanadoo.fr>...
Dear group, here is my problem

In the code of a form, i want to declare a variable :

Dim Base_Photo as Database, But Access 2000 don't propose
"Database" and don't accept it.

But, in an other Base, with Access 2000, this is possible and
accepted and works !

I did not find the différence, could you help me ?

Thank You


Alain,

When you create a new access mdb-file ADO is the default library, not
DAO like in Access 97. Just add the DAO 3.6 library or replace the ADO
library for DAO. When you are in the module look in the references
option in the tools menu. Database is not part of the ADO
object-model. If you don't want to use ADO don't declare the
library-reference. Then you are not confused by several ADO oriented
help-files if you need help.

Marc
Nov 12 '05 #3

P: n/a
Thank you to you three. I think the other DB which works was
converted from Access 97. Thanks again
--
_________________________________

Site photo personnel :

http://perso.wanadoo.fr/dimphoto
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.