Cannot open any more databases

  • Thread starter Thread starter Debbie Gilbert
  • Start date Start date
D

Debbie Gilbert

When running a report..I get the message "Cannot open any
more databases." Run-time error 3048... Has anyone seen
this message before?
 
When you open recordsets in memory to evaluate/calaulate data, etc., you
must close them otherwise they remain in memory, clogging it up. Therefore,
always close the recordset at the end, as shown below.

Dim rst As DAO.Recordset
'all your code is in here
rst.Close
Tom.
 

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

Cannot open any more databases (3048) 4
Error 3048 4
Can't create a report from my query in Access 1
Error - Cannot open any more databases... 6
Error 3048: Cannot open any more databases 2
Cannot open any more databases. (Error 3048) 1
Print errors 1
Office 2003 Access Report will not run in Vista, but will run in X 2

Back
Top