Access limitations?

  • Thread starter Thread starter ORJAN
  • Start date Start date
O

ORJAN

Hi,
is there a limit regarding the size of an Access database in mB
or number of records (products) in a table?
My database contains of 6 tables (the largest with 40 fields in it)
and a client will use this databas for some 80.000 items.
I understand that it has to do with the amount of data in each item
but is there a sort of general limitation?
 
For the most part, 80,000 records is quite a small table.

There is no real rule, but you do want to limit the data that person brings
into a form.

It also not clear is this is going to be multi-user, and a network is
invoicled.

if it just on your single desktop, that number of reocrds is really nothing
to worry about...
 
Hi,
is there a limit regarding the size of an Access database in mB
or number of records (products) in a table?
My database contains of 6 tables (the largest with 40 fields in it)
and a client will use this databas for some 80.000 items.
I understand that it has to do with the amount of data in each item
but is there a sort of general limitation?
Click to expand...

Take a look in the online help - search for "Specifications".

The entire .mdb file is limited to 2 GByte (two billion bytes). I know of
working Access databases with 20,000,000 records in the largest table. You're
nowhere CLOSE to being too big!

There is one rather insidious limit: a single record can contain no more than
4000 bytes (2000 characters if you use Unicode). You can have a table with 40
fields; but if 25 of them are 255-byte Text fields, you may someday try to
enter a record with more text in those fields than will fit, and get an error.
 
It also not clear is this is going to be multi-user, and a network
is invoicled.
Click to expand...

Whenever a network is invoicled, things become very confused, I've
found.
 
Back
Top