 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / September 2007LIMITATION ON ACCESS 2003 DATABASE
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? 8k records is tiny. A well-designed Access database can cope with millions of records.  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > 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 [quoted text clipped - 7 lines] > records? or how often does one have to do "compact and repair > database" on a database? 2GB filesize is the limit. If it's placed on a network share that may be (part of the reason) for the corruption Pieter > 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 [quoted text clipped - 7 lines] > records? or how often does one have to do "compact and repair > database" on a database? Also check www.allenbrowne.com for several other, including "name autocorruption" (autocorrect) hth Pieter > 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 [quoted text clipped - 7 lines] > records? or how often does one have to do "compact and repair > database" on a database? 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 SignatureJerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > 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 [quoted text clipped - 7 lines] > records? or how often does one have to do "compact and repair > database" on a database? >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 [quoted text clipped - 3 lines] >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 SignatureTony 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/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.