Access limitations?

[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?

 

[scubadiver]

I have read that 2GB is the largest memory size.

 

[Albert D. Kallal]

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...

 

[John W. Vinson]

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?

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.

 

[tony]

VISITA IL MIO SITO WWW.ZAJON.IT
VISIT MY WEBSITE HELO?

 

[Tony Toews [MVP]]

I have read that 2GB is the largest memory size.

Actually that is largest file size.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

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

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