database size or record limit

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.

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


"Ijaz Ahmed" Ijaz wrote in message
...
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.

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

Check Access Help on "Specifications".

--
HTH
Van T. Dinh
MVP (Access)


"Ijaz Ahmed" Ijaz wrote in message
...
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.