Maximum Access Size

[collinsc]

Hi All

We have a database in Access 97 which is 0.8GB.

Can anyone tell me:
a) The maximum storage capacity.
b) What will happen when it reaches that size!

Thanks very much

 

[edtab]

Access 97 has a 1GB capacity. Once you reach this,
you can not add or edit records. You also can not
compact or repair the database.

 

[GMLWORLDCHAMP!]

Time to split...

This will help for a while until you begin to reach that documented 1GB file size limit...SPLIT DATABASE...

http://msdn.microsoft.com/archive/en-us/dnaracc97/html/msdn_sharedb.asp?frame=true

Upgrade to 2000 or better and the file size limit goes to 2GB...

 

[collinsc]

Thanks very much