Size MS Acess Database

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.
 
J

John Vinson

What is the maximum size a database can be before it
becomes corrupted or impaired?

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top