Max Records

[JMB]

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!

 

[tina]

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

contain? I want to work with a data base of 250,000
records...

 

[Jeff Clark]

250,000 is small potatoes

What's the maximum number of records an Access table can contain? I want

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

 

[John Vinson]

250,000 is small potatoes

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

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 (!)

 

[Outpost]

We were crunching 2 million records in A2K. Ensure you have your indexes set up.