DataBase Size

[ksimmsa]

How large or how much data can the database hold. I have a DB with several large tables. I back up the DB daily, but at what point should I look to make a posible purge, create a new DB or is there a way to store the old info and still be able to access it form the main database?


Thanks in advance for your help!!!!!

 

[BNPMike]

Firstly if your data exceeds the limit of the Jet database (2GB?) you are probably using the wrong tool.

However if it does, you have simple options eg:

1) Partition the database into more tham one mdb, then link to affected tables from your controlling applications

2) Upsize to MSDE (ie a 'project')