CurrentDb is nothing!

kLAcK

Registered User.
Local time
Yesterday, 23:50
Joined
Jun 22, 2007
Messages
19
I am trying to access the CurrentDb.QueryDefs collection, but the CurrentDb object is nothing!

Here is my simple code=

Code:
debug.print CurrentDb.QueryDefs.Count

I get the "Object variable or With block variable not set" error message. Is this because I am using an Access Database Project, and the database is actually stored on a SQL server?
 
Found the answer, and I guess ADP's can't use the currentdb object.
 

Users who are viewing this thread

Back
Top Bottom