LIMITATION ON ACCESS 2003 DATABASE

[Joey]

Could anyone tell me whether there is a limit to the number of records
which can be stored in a table in an Access 2003 database. I have an
Access dbase with approximately 8463 records already and growing day
by day. I find that sometimes all records can't be read (I run a
document management system from the database whereby I lookup data and
documents previously created). After getting the error I rebuild and
compact the database and all runs fine for a while again. Then it
doesn't read all the records again for some or other reason. I repeat
the process and all fine. Is there a limitation to the number of
records? or how often does one have to do "compact and repair
database" on a database?

 

[Allen Browne]

8k records is tiny.

A well-designed Access database can cope with millions of records.

 

[Pieter Wijnen]

2GB filesize is the limit.
If it's placed on a network share that may be (part of the reason) for the
corruption

Pieter

 

[Pieter Wijnen]

Also check www.allenbrowne.com for several other, including "name
autocorruption" (autocorrect)

hth

Pieter

 

[Jerry Whittle]

The maximum number of records is a little over 133 MILLION records. Therefore
the number of records isn't your problem. Rather you have a corruption
problem.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Tony Toews [MVP]]

Could anyone tell me whether there is a limit to the number of records
which can be stored in a table in an Access 2003 database. I have an
Access dbase with approximately 8463 records already and growing day
by day. I find that sometimes all records can't be read (I run a
document management system from the database whereby I lookup data and
documents previously created). After getting the error I rebuild and
compact the database and all runs fine for a while again.

As you have been told that is tiny. I have a client with 400K and
800K records in the same MDB. It has a total of 160 tables totaling
300 Mb.

However what is the exact message you have been getting? Please post
back with that when you get the message in the future.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/