Limit on number of queries open in Access 2007?

D

Daryl S

I am creating an application in Access 2007 and want to run a batch of
queries at a time. When I hit the 11th query, I get the run-time error
'3021': No current record. If I run the queries manually, I get a diolog box
saying 'Cannot open any more databases'. The Help button tells me it is
Error 3048, but I can't find any information on this. These queries are
small (the database is small). In prior versions of Access I have run
batches of 50 queries without this issue. These are all select queries - no
action queries. The individual queries all run fine without problems.

Any suggestions on how to get around this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing Access MDB or Accdb with client using older or newer version of Office 1
MS Oracle ODBC failure in Access 07 3
Pass-through queries not displaying in navigation window 1
I can create Publisher documents, but I can not open / read them. 0
Running queries with low priority in ado.net on access database 5
queries not recognizing vba functions 2
queries delete temselves after i print my reports 0
Sharing CSV files with Access 9

Top