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.
 
Back
Top