Do I need to reinstall?

  • Thread starter Thread starter shaggles
  • Start date Start date
S

shaggles

I'm having a weird problem with Access 2000. I'm trying
to create an add new function but Access isn't recognizing
some og the keywords. Specifically 'Database'
and 'dbOpenDynaset'. is this a problem with the install?
I've used both of these in Access 97 and although it's the
first time I've tried this in 2000 I can't believe
Microsoft would have changed 'Database'.
 
dbOpenDynaset and the Database object are DAO objects. By default, Access
2000 comes with ADO loaded. All you need to do is set a reference to DAO by
opening any code window and going to Tools > References... and selecting
Microsoft DAO 3.6 Object Library from the list (check the box).

Also, you should either remove ADO or explicitly reference you object model:

Dim db as DAO.Database

For more information, go here:
http://members.iinet.net.au/~allenbrowne/ser-38.html
 
Thanks Roger. I'll give that a try.
-----Original Message-----
dbOpenDynaset and the Database object are DAO objects. By default, Access
2000 comes with ADO loaded. All you need to do is set a reference to DAO by
opening any code window and going to Tools > References... and selecting
Microsoft DAO 3.6 Object Library from the list (check the box).

Also, you should either remove ADO or explicitly reference you object model:

Dim db as DAO.Database

For more information, go here:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org




.
Click to expand...
 
shaggles said:
I'm having a weird problem with Access 2000. I'm trying
to create an add new function but Access isn't recognizing
some og the keywords. Specifically 'Database'
and 'dbOpenDynaset'. is this a problem with the install?
I've used both of these in Access 97 and although it's the
first time I've tried this in 2000 I can't believe
Microsoft would have changed 'Database'.
Click to expand...


It sounds like you're missing a Reference to the DAO
library. (In any code module, use the Tools - References
menu item).
 
Back
Top