database size or record limit

[Ijaz Ahmed]

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.

 

[Kevin3NF]

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

 

[Van T. Dinh]

The REcord size is 2K but Memo & OLE Fields are not included.

Check Access Help on "Specifications".