LIMITATION ON ACCESS 2003 DATABASE

J

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?
 
A

Allen Browne

8k records is tiny.

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

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
 
J

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
 
T

Tony Toews [MVP]

Joey said:
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/
 

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