C
cartha_am
For instance, how many records can I have in a table, or how many table can I
have in a database?
have in a database?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Have you tried using the help files?
Type "specifications" in HELP.
Type "specifications" in HELP.
A
Aaron
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.
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.
F
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
A
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....
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....
C
cartha_am
Thank you all