Size of Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

At what point should I be concerned at the size of a database. My database
has been in production for 3 years and I'm concerned that at some point the
performance will be negatively impacted due to its size
 
The theoretical limit for Access 2000 and later is 2GB.

If you are pushing 1GB after compacting, it is probably time to consider
alternatives:
- Any OLE fields that can be removed?
- Any images that can be linked instead of embedded (in forms, reports)?
- Is there a large table that could be placed in a separate MDB (and
linked)?
- Do I need a larger database (Oracle, SQL Server)?
 
Thanks so much Allen for this information, it is a huge help to me and I
appreciate you passing it along to me. Enjoy your long holiday weekend. Joyce
 
Back
Top