No. of Records

  • Thread starter Maximum Number of Records... In Access
  • Start date
M

Maximum Number of Records... In Access

Have any boundation for total no. number of records store in a Table/File.
Because I have facing a problem in Access that system shown an error "
Invalid Argument" .The said error shown after 40,00,000-48,00,000 records
store.

I have also facing an error after 40-48 lac records store. I have run a
query successfully. but at the time of saving to query the same problem has
shown "Invalid Argumnet"....

Govind K Mishra
09350115513
 
M

Maximum Number of Records... In Access

Maximum Number of Records... In Access said:
Have any boundation for total no. number of records store in a Table/File.
Because I have facing a problem in Access that system shown an error "
Invalid Argument" .The said error shown after 40,00,000-48,00,000 records
store.

I have also facing an error after 40-48 lac records store. I have run a
query successfully. but at the time of saving to query the same problem has
shown "Invalid Argumnet"....

Govind K Mishra
09350115513
Click to expand...
 
J

John Vinson

In
Have any boundation for total no. number of records store in a Table/File.
Because I have facing a problem in Access that system shown an error "
Invalid Argument" .The said error shown after 40,00,000-48,00,000 records
store.

I have also facing an error after 40-48 lac records store. I have run a
query successfully. but at the time of saving to query the same problem has
shown "Invalid Argumnet"....

Govind K Mishra
09350115513
Click to expand...

An Access .mdb file is limited to 2 GBytes (including all tables,
forms, systems tables and overhead). See "Specifications" in the
online help.

I'm sorry, I'm not familiar with your numbering system: but if you
have four million (4.0 x 10^6) records in your tables, you are
probably pushing Access rather hard. The largest Access application of
which I am aware has a 20,000,000 record table, but it's unusual.

Are you using Tools... Database Utilities... Compact and Repair
Database regularly?

John W. Vinson[MVP]
 
Top