Error "too many databases open"

[jim]

I have a DB that uses a recordset on one form and fills a table on another
form with a record for each day of the year. It only runs a couple of
months then gives me an error message (Error 3048) telling me I have too
many databases open. I assume it has something to do with the
recordsetclone being opened too many times (once per date.) I also have it
opening and closing two forms over and over. Where am I going wrong?

Thanks!

 

[pietlinden]

I have a DB that uses a recordset on one form and fills a table on another
form with a record for each day of the year. It only runs a couple of
months then gives me an error message (Error 3048) telling me I have too
many databases open. I assume it has something to do with the
recordsetclone being opened too many times (once per date.) I also have it
opening and closing two forms over and over. Where am I going wrong?

Thanks!

do you close and dereference all your objects?

rst.Close
set rst=Nothing

 

[jim]

I added the code you suggested with no change. I'm wondering if it is
because of opening and closing forms. I have all my code in form "load" and
I suspect that's my problem. What's a better way to do a loop that needs
to access multiple forms?

Thanks!