Cannot open any more databases

[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?

 

[tom]

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.