database size or record limit

G

Guest

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.
 
V

Van T. Dinh

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

Check Access Help on "Specifications".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Text field size 1
Access 2003 bloating 2
About Access limits 15
How big can an Access table be? 5
access 2.0 limts 2
Limit number of records returned from query 5
SQL Server 2008 R2 Express Database Size Limit Increased to 10GB 3

Top