G
Guest
Our department is going to access 2000, however, It's known that access have
a record or data storage size limitation
What is it exactly.
a record or data storage size limitation
What is it exactly.
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.
A
Alex Dybenko
Size of DB is max 2GB
B
Brendan Reynolds
2 gigabytes when using the Jet database engine (the default for an MDB). You
can, of course, use Access as a front-end to server databases such as SQL
Server, if you need to store more than 2 gigabytes of data.
can, of course, use Access as a front-end to server databases such as SQL
Server, if you need to store more than 2 gigabytes of data.
A
Albert D. Kallal
The limitation is not the number of records, but in fact how many records
you can fit in the limited space.
So, if your records are large in size, then you fit "less" records into the
fixed max size. So, there is no record limit per see, but only a file size
limitation.
in access 2000, that file size limit is 2 gig.
An average name in a mailing list takes about 85 characters. So, some simple
math shows:
2 gig = 2 billion characters.
2,000,000,000 / 85 = 23, 529,411
So, you get 23 million addresses you can fit. However, if each record was
170 characters in length, then you would get 1/2 of 23 million.
you can fit in the limited space.
So, if your records are large in size, then you fit "less" records into the
fixed max size. So, there is no record limit per see, but only a file size
limitation.
in access 2000, that file size limit is 2 gig.
An average name in a mailing list takes about 85 characters. So, some simple
math shows:
2 gig = 2 billion characters.
2,000,000,000 / 85 = 23, 529,411
So, you get 23 million addresses you can fit. However, if each record was
170 characters in length, then you would get 1/2 of 23 million.
M
Mark M
Along with what others have said, you can find out more about limits and
other things by typing "specifications" into the Access Help screen. Might
be some other useful info you might be interested in.
other things by typing "specifications" into the Access Help screen. Might
be some other useful info you might be interested in.
D
david epsom dot com dot au
Access stores data in files on your hard disk.
If you want more data, you just link to more
files. So the limitation is how much space you
have on your hard drive + space on all your
file servers.
Of course, you might find that there are other
limitations on how much data you wish to store
in Access, even though there is no hard technical
limit.
(david)
If you want more data, you just link to more
files. So the limitation is how much space you
have on your hard drive + space on all your
file servers.
Of course, you might find that there are other
limitations on how much data you wish to store
in Access, even though there is no hard technical
limit.
(david)