Size of 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,
Thank You.
 
Your network (or a user on that network) is probably the cause of your
corruption.

I have a client who has an Access 2.0 database which connects to 78 other
databases which vary in size from a few hundred MBs to 800 MBs. They've had
1 minor corruption in the 4 years I have been servicing them.

Poor design or a poor network can both contribute to or cause corruption.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Make sure all network computers are running the same version Jet 4.0.
Service Pack 7 is the most recent.

Gregory La Due
Twin Tiers Technologies, Inc
 
J said:
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,
Thank You.
Click to expand...

See Tony Toews' Corrupt MDB FAQ page:

http://www.granite.ab.ca/access/corruptmdbs.htm
 
J said:
What is the maximum size a database can be before it
becomes corrupted or impaired?
Click to expand...

Size has very little if anything to do with the chances of being
corrupt.
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.
Click to expand...

Almost certainly the OpLocks problem which hits A2000 much more than
it does A97.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top