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

currentdb

P: n/a
Hi everyone,
i'm getting lost here...
used to work with Access97 now Access2002

I'm having trouble finding currentdb

Following references are checked:
vb for applications
MsAccess 10.0 object library
Ms DAO 3.6 object library
Ole automation
MS VB for applications extensibility 5.3
some posted messages referred to the DAO 3.6 object library but to no
avail.

thanks for your help
Paul

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
CurrentDb is supplied by the DAO library.
You can try unselecting the last two unless you specially need them.

What error do you receive if you open the Immediate Window (Ctrl+G) and
enter:
? CurrentDb.Name

General info on references and how to ensure the correct files are present
and registered:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"polux" <po***@skynet.be> wrote in message
news:j0********************************@4ax.com...
Hi everyone,
i'm getting lost here...
used to work with Access97 now Access2002

I'm having trouble finding currentdb

Following references are checked:
vb for applications
MsAccess 10.0 object library
Ms DAO 3.6 object library
Ole automation
MS VB for applications extensibility 5.3
some posted messages referred to the DAO 3.6 object library but to no
avail.

thanks for your help
Paul

Nov 13 '05 #2

P: n/a
Actually, CurrentDb is a member of the Application object and should be
automatically available regardless of whether the DAO library is explicitly
referenced. You only need the DAO reference to declare create early-bound
references to DAO objects.

On Mon, 6 Dec 2004 19:19:27 +0800, "Allen Browne" <Al*********@SeeSig.Invalid>
wrote:
CurrentDb is supplied by the DAO library.
You can try unselecting the last two unless you specially need them.

What error do you receive if you open the Immediate Window (Ctrl+G) and
enter:
? CurrentDb.Name

General info on references and how to ensure the correct files are present
and registered:
http://members.iinet.net.au/~allenbrowne/ser-38.html


Nov 13 '05 #3

P: n/a
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:41***********************@per-qv1-newsreader-01.iinet.net.au:
CurrentDb is supplied by the DAO library.


Yes, but it's also supplied by the Application object,
Application.DBEngine.

That is, there should never be a case where DBEngine fails because
of a reference error on the DAO library.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

P: 1
Hello,
I get the same error too when using a database created using Access 2000 in Access 2003. When I ask for Currentdb.Name in the immediate window, I get a "ActiveX Component cannot create object" error.

Can anybody help, please?

Thank you in advance.
Chandra

Actually, CurrentDb is a member of the Application object and should be
automatically available regardless of whether the DAO library is explicitly
referenced. You only need the DAO reference to declare create early-bound
references to DAO objects.

On Mon, 6 Dec 2004 19:19:27 +0800, "Allen Browne" <AllenBrowne@SeeSig.Invalid>
wrote:
[color=blue]
>CurrentDb is supplied by the DAO library.
>You can try unselecting the last two unless you specially need them.
>
>What error do you receive if you open the Immediate Window (Ctrl+G) and
>enter:
> ? CurrentDb.Name
>
>General info on references and how to ensure the correct files are present
>and registered:
> http://members.iinet.net.au/~allenbrowne/ser-38.html[/color]
Apr 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.