Limitations of access

[Felix]

im new in access, wish to konw the limitations like how many database can it handle, how many tables per dbase, how many record/table ? my project needs quite a big dbase and i hear that access dbase has a narrow limitation... many thanks in advance

 

[Cheryl Fischer]

Felix,

There is no specific "records per table" specification for MS Access. In
Access 97 or older, a single MDB file can be as large as 1 GB; for Access
2000 and newer, the database size limitation is 2 GB. To view other
specifications, open your copy of Access, click Help, and in the Answer
Wizard type the word: specifications.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

im new in access, wish to konw the limitations like how many database can

it handle, how many tables per dbase, how many record/table ? my project
needs quite a big dbase and i hear that access dbase has a narrow
limitation... many thanks in advance

 

[Kevin3NF]

Felix,

In addition to Cheryl's answer, if you provide some specs as to what your
project needs, we may be able to guide.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

im new in access, wish to konw the limitations like how many database can

it handle, how many tables per dbase, how many record/table ? my project
needs quite a big dbase and i hear that access dbase has a narrow
limitation... many thanks in advance

 

[Rolls]

Access is a greatly underestimated application. The negative opinions come
from older Cobol mainframe programmers who haven't learned SQL and
normalization. When there are problems with Access the first thing to
analyze is table normalization.

What's good about Access is that powerful applications may be developed
quickly. It's limitations are security and data capacity. If you have
payroll data or more than a million records or more than 10 people who need
simultaneous access to your app then consider SQL Server as a backend for
improved security, size, and speed.

If your applications are for a workgroup you may very well not outgrow it.

 

[Michel Walsh]

Hi,

Note that the limit of 10 users seems to sometimes be linked to the OS
on which is based the database. Indeed, if the OS is XP, or, in general,
NOT a SERVER, there is a limit, a max, of 10 active connections at a given
shared resources. You need a server (NT 4 Server, W2000 Server, or W2003
Server) to increase that Operating System limitation.



Hoping it may help,
Vanderghast, Access MVP

 

[StCyrM]

Hi

Siince you don't specify what version you have, here are the specs. for Access
97. Hope that this is of some help to you.

Best regards

Maurice St-cyr
Micro Systems Consultants, Inc.


Database (.mdb) file size 1 gigabyte.
However, because your database can include linked tables in other files, its
total size is limited only by available storage capacity.

Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user
interface;
1gigabyte when entering data programmatically.

Form or report width 22 in. (55.87 cm)
Section height 22 in. (55.87 cm)
Height of all sections plus section headers (in Design view) 200 in. (508 cm)

Number of levels of nested forms or reports 3
Number of fields or expressions you can sort or group on in a report 10
Number of controls and sections you can add over the lifetime of the form or
report 754

 

[Steve]

Hi Kevin.I thought i would jump in here to see if you
could answer my question,I have a database with over
600,000 Baptisms and want to know if Access can handle
that size database.The data fits onto 1 CD so is less
than 1Gb,I have tried OpenOffice which i was told was as
good as Access but that will only let me import 32,000
than i get an error message that it's limitations have
been reached.What i want to be able to do is search the
data base and group together baptisms that have the same
parents or are from the same town.

Steve

 

[Douglas J. Steele]

While a lot depends on how much information is stored with each baptism,
600,000 shouldn't be too much for Access to handle.

 

[Guest]

Thanks Douglas,Each baptism will have no more than 13
seperate bits of information for each one.So i should be
ok then ?

Steve

 

[Douglas J. Steele]

Shouldn't be a problem.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Thanks Douglas,Each baptism will have no more than 13
seperate bits of information for each one.So i should be
ok then ?

Steve

 

[Steve]

Thanks for your help Douglas. Steve

-----Original Message-----
Shouldn't be a problem.

 

[felix]

many thanx to all of u!!