Size MS Acess Database

  • Thread starter Thread starter J
  • Start date Start date
J

J

What is the maximum size a database can be before it
becomes corrupted or impaired? I just converted a database
from Access 97 to Access 2000. In conjuction I switched it
from a Windows NT Server to Windows 2000 server. Having a
few problems. The database is approximately 117 MB and I
have several (approximately 11 linked tables from other
databases) whose size average from 1.98 MB to 10MB and on
an average since I have switched to 2000 I have had to
repair it twice a day. Not to sure what's causing the
corruptions. I have the same amount of users using it as
before and I didn't have any complications. Please advise.
 
What is the maximum size a database can be before it
becomes corrupted or impaired?
Click to expand...

1 GByte in A97, 2 GByte in A200x. However, corruption can occur in ANY
size database - small or large, though IME large databases are
somewhat more vulnerable.
I just converted a database
from Access 97 to Access 2000. In conjuction I switched it
from a Windows NT Server to Windows 2000 server. Having a
few problems. The database is approximately 117 MB and I
have several (approximately 11 linked tables from other
databases) whose size average from 1.98 MB to 10MB and on
an average since I have switched to 2000 I have had to
repair it twice a day. Not to sure what's causing the
corruptions. I have the same amount of users using it as
before and I didn't have any complications. Please advise.
Click to expand...

Check your network hardware. Access is EXTREMELY sensitive to bad NICs
and network noise, more so than most other applications.

Also see Tony Toews' excellent Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm.
 
Back
Top