G Guest Jun 23, 2005 #1 what is the limit of record of an acees database, if i insert 100,000 records of 12 fields table with the field size of 50.
what is the limit of record of an acees database, if i insert 100,000 records of 12 fields table with the field size of 50.
K Kevin3NF Jun 23, 2005 #2 2GB file size for Access 2000 or newer, nothing explicit for number of records. Access can easily handle 100K records (600K record size is fine...) -- Kevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. www.experts-exchange.com - experts compete for points to answer your questions
2GB file size for Access 2000 or newer, nothing explicit for number of records. Access can easily handle 100K records (600K record size is fine...) -- Kevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. www.experts-exchange.com - experts compete for points to answer your questions
V Van T. Dinh Jun 23, 2005 #3 The REcord size is 2K but Memo & OLE Fields are not included. Check Access Help on "Specifications".
