Hi, I am new to Access 2003 on XP. I am creating a database from a current report that has exceeded Excel 2003's row limitation. My concern is running into an Access limitation after creating the database. I have read the post entitled "How to overcome the size limitation of MSAccess" and it was very helpful. However, is there a definitive answer as to how many records a 2GB database can hold? or is it dependent upon the record size (2 fields vs. 20 fields)? The idea of creating multiple databases and then linking the tables is also a viable option for me. Has anyone run any to problems with this solution I should know about before I begin? All help/advice is GREATLY appreciated!
-
-
The maximum number of records is defined by the size and number of fields.
I have successfully linked several databases in the past, but never to the size you are describing.
I only hit the 2GB limit once, and that was because I was inserting pictures, which Access converted to bitmaps.
A database that is very active, lots of records adding and deleting, will also grow quickly. Regular compacting is often necessary. -
There are two things that you can do. As said before be sure that you are regularly compacting and reparing your database through "tools> database utlities> compact and repair database" this usually takes care of most problems. Another solution is to basically split your database in two. So that data is linked from two databases both which contain half of the information. this way you can get two 1 gig databases instead of one full 2 gig database. To do this you would simply open a blank database and import the tables you need. then go back to the main database (where entry of records occurs) and then just link the tables.Comment
Comment