record limit

A

Allen Browne

There is no limit to the number of records in a table.
The practical limit is that the database size cannot exceed 2GB.
 
J

John Vinson

hi,

How many records can I have in ms access? what is the limit.
thanks
Click to expand...

No specific limit, as Allen says; in practice, about the largest
production Access database table that I know of has some 20,000,000
records. Tens to hundreds of thousands of records are quite routine
and managable.

John W. Vinson[MVP]
 

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

Is there any place I can get screen shots of Outlook Web Mail screens with notations? 0
Merge Excel file into Word Document 3
Printing Styles page 0
Default local file location - folder redirection slowness 0
Difficulty with compatibility mode and Track Changes 2
MS Exchange PTR 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Line callout arrow in a drawing canvas 1

Top