Error "There Isn't Enough Free Memory"

[Guest]

You may have too many open connections to the database on
the workstation. This can occur if you are opening
recordsets ("db.openrecordset") Each time you
programmatically open a recordset, you need to close it
("db.close") - else you leave it open and everytime the
user runs the piece of code that opens a connection to the
database, it reduces the available memory. This scenario
for me is with a split backend/frontend database where the
frontend is local and the backend is a shared mdb file.

Hope it helps.

 

[Guest]

Excellent, thank you for the response. Was thinking I wasn't going to get
one, ha. . .

Now, based on your post, I understand what's going on, however I'm not very
"code" literate. Any suggestions on fixing this issue? (assuming there is a
fix) And you were right, it is a front end, back end split. However I have
nearly 65 users, and it only happens to some.