a elemental question

  • Thread starter Thread starter knit
  • Start date Start date
K

knit

can I know from you how many records one access database can have? I have
over 10,000 pieces of records, can I use Access to manage these records?
 
10,000 piece of cake
100,000 no problem
1,000,000 Possible, but if you see it coming before you begin, you may
want to move to a bigger database.
 
-----Original Message-----
can I know from you how many records one access database can have? I have
over 10,000 pieces of records, can I use Access to manage these records?

I have had tables wit over 300 000 records in it before,
Click to expand...
so 10 000 records is fine.

Leon
 
can I know from you how many records one access database can have? I have
over 10,000 pieces of records, can I use Access to manage these records?
Click to expand...

You're limited to 2 billion bytes in the entire .mdb file.

The largest production Access database of which I am aware has some
50,000,000 records in its largest (of many) table. I'd have moved to
SQL/Server before it got that big but the user seems happy with it.
 
Back
Top