maximum table size

M

michael c

does anyone know the maximum number of records that a
table can hold? i have about 165,000 entries i'm hoping to
bring in from several spreadsheets but i'm thinking i
might have to use a multiple database linking strategy.
 
K

Kevin3NF

No limit on # of records. Size per record, and total database size yes...I
have heard of tables with millions of records. Just make sure to use proper
indexing, as well as compact and repair regularly.
 

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

Creating a Search using a combo box and then creating a report. 4
Cumulative formula for word table 0
table design feedback request for plating shop bath testing 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
ASK Field Formatting 1
find out size of each table 1
Limit on number of fields in MS Access forms 3
Maximum record size and maximum number of records 3

Top