What is maxium # of records per table Access 2000?
L Lynn Trapp Jun 10, 2004 #2 As many records as it takes to reach the maximum file size of 2GB. A record has a maximum of 2,000 bytes and, thus, if you maxed out every record, you could have around 1,000,000 records. However, it's not likely that you will max out many records.
As many records as it takes to reach the maximum file size of 2GB. A record has a maximum of 2,000 bytes and, thus, if you maxed out every record, you could have around 1,000,000 records. However, it's not likely that you will max out many records.
T tina Jun 10, 2004 #3 open Access Help and do a search on "specifications". you'll get all the db specs, including those for tables. hth
open Access Help and do a search on "specifications". you'll get all the db specs, including those for tables. hth
