Size of Database

S

SITCFanTN

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
 
A

Allen Browne

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)?
 
S

SITCFanTN

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
 
Top