Max Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What's the maximum number of records an Access table can contain? I want to work with a data base of 250,000 records..

Thanks!
 
no max number of records. max table size (in A2K) is 1 GB.
to see all the specifications: open Access Help, go to the
Answer Wizard tab, and type "what are the
specifications?". you get a list of specifications to
choose from which should tell you everything you'd ever
want to know about Access specifications (more, probably!).

hth

-----Original Message-----
What's the maximum number of records an Access table can
Click to expand...
contain? I want to work with a data base of 250,000
records...
 
250,000 is small potatoes

to work with a data base of 250,000 records...
Click to expand...

Yep. The 1,000,000 is getting respectable; I know of several databases
with between one and ten million; and of one stock-ticker database
with over 100,000,000 records (!)
 

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

Pivot using 250,000 rows of data in Excel? 1
record locking issues and upgrading to 2007 or SQL 3
Maximum record size and maximum number of records 3
Record-Locking remains open after closing 0
About Access limits 15
How big can an Access table be? 5
Number of records 3
Rounding difference in Access 2003 text exports 2

Back
Top