Max # of Databases in one instance of Access

M

Mike

What is the the maximum number of databases that can be
open during a single instance of Access 2000? What
problems can occur if using the max or close to? what
performance issues?
 
V

Van T. Dinh

Do you mean opening Access software, opening a database, closing it, opening
another database, closing it, ...

No limits AFAIK since Access should close the previous database completely
before opening a new one. However, there are cases where Access cannot
close down a database due to objects your VBA code creates but not destroyed
afterwards.
 

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

Footnote references on one page, footnote text on the next 5
Hyperlink fails to open on the first click 0
Access Lock File .LACCDB / Now shows as a notepad file 0
How to return Max date or Null (if there is a Null present) 4
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Use of Max is quite working 4
How do I clear a form? 0
return one instance of account number 3

Top