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!
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
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
records...
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
contain? I want to work with a data base of 250,000-----Original Message-----
What's the maximum number of records an Access table can
records...
J
Jeff Clark
250,000 is small potatoes
to work with a data base of 250,000 records...JMB said:What's the maximum number of records an Access table can contain? I want
J
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 (!)
O
Outpost
We were crunching 2 million records in A2K. Ensure you have your indexes set up.