What amount of data I am able to manage with Acces?

[Guest]

For instance, how many records can I have in a table, or how many table can I
have in a database?

 

[Rick B]

Have you tried using the help files?

Type "specifications" in HELP.

 

[Guest]

You can find all of the specs for Access on the help file. Press F1 in Access
and if you want all of the specs. Go to the "Start up and Specs" folder and
look for "Access specifications".

2gb is the largest table size. 2048 tables can be opened. Can have 32 tables
in a query, etc. etc.

Hope that helps.

 

[fredg]

For instance, how many records can I have in a table, or how many table can I
have in a database?

Click on
Help + Index + Specification + Access Specifications

 

[Albert D.Kallal]

The size limit of access 2002 is 2 gigs.

So, if you take a average name in a mailing list, add a few extra
fields...your record size might be about 120 characters on average in size.

So, the number of records you can store is:

2 gig / 120 = 32 million records

So, the limit is NOT the number of records..but "how many" records you can
fit into 2 gig.

Of course, if each customer name only takes up 60 characters...then you can
store 64 million records in the file.

How many records do you plan to store? In real terms, I don't think anyone
would store close to the actual limits of the file size for ms-access when
not using sql server. I think in real terms....a few hundred thousands
records is certainly fine with ms-access.

So, a file file with 100,000 records in ms-access is rather small....

 

[Guest]

Thank you all