Max # of Databases in one instance of Access

  • Thread starter Thread starter Mike
  • Start date Start date
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?
 
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.
 
Back
Top