Maximum data size or rows

  • Thread starter Thread starter jj
  • Start date Start date
J

jj

Is there a maximum data size(MB) an Access table is supposed to hold? Or a
maximum number or rows?

concerned
jj
 
For a particular table? Not that I know of.

Number of rows? Largely depends on the data type for the primary key.

For a database, however, Access begins to really puke around 50MB in most
instances. You can get much larger than that, but it is not efficient.


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 

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

Maximum capacity (Mb) or number of rows 2
Excel Returning Multiple Results (closest Match Not Exact) From A Table Using Multiple Criteria 1
What makes people want to buy this NetBook 2
Inserting SSD to new kit 1
Maximum record size and maximum number of records 3
maximum number of rows in DataTable. 1
German stock exchange to launch marketplace for video game objects 2
Ms Access size? 2

Back
Top