QUOTE(Rong63 @ 31 Jul, 2008 - 01:35 PM)
QUOTE(rgfirefly24 @ 31 Jul, 2008 - 11:35 AM)
Ok I see the size of the database will max out at 2GB, Is the 32k of objects talking about number of files or everything all together ie macros reports, files etc? The size is no problem since the db is right at 14.6 mb. Attached is a sample record of what I am talking about...... so its not files I am looking for its actually max number of records in a database,
basically what its saying is that the max records that can fit into a single table will never excede 2gb of data usage. So lets take this into relation you said you have 16724 records currently taking up 14.6mb
if i figure it correctly each record takes .0008 mb of storage 2 gigs is 2048 mbs of data. so if we take 2048 and divide it by .0008 you get a total of 2,560,000. So access theoretically can hold 2,560,000 records per table. (note: my math could be way way way off but i tried)
Hello I am inquiring about the maximum number of records that a single Access database will hold before its full. Right now I am sitting at 16724, seems like I heard it will max out at 24000. Does that sound correct and if so do I just start the new one with all but first record deleted?
| 