maximum database size access97

[fustrated]

I have a database that is +/-1gb in size however I can't
enter any new data becuase of an error that comes up that
the maximum database size has been reached.
What IS the maximum database size?
What can I do to continue working?
Thanx in advance

 

[Dan Artuso]

Hi,
1GB is the max size for Acc97.
Do you compact the db regularly?
If you do and it's still 1GB, you can move some tables to
another mdb and link to them.

 

[Scott Shearer]

You may want to seriously consider moving to a newer version of Access - the Access 2002 specs say that the maximum file size is 2 gb. If your database is approaching 1 gb and you are in a multi-user environment, you can expect to start seeing database corruption (if you haven't seen this already). Think about migrating to SQL Server 2000 or MSDE (free with MS Office) and migrating your Access forms to an Access project (.adp).

Scott Shearer, MCSD, MCBDA
****msshearer@@@hotmail.com********


----- fustrated wrote: -----

I have a database that is +/-1gb in size however I can't
enter any new data becuase of an error that comes up that
the maximum database size has been reached.
What IS the maximum database size?
What can I do to continue working?
Thanx in advance