G
Guest
What is the largest recommend file size of a Microsoft
Access Database?
Access 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.
K
Ken Snell
2 GB is max size possible. Recommended is any size less than that.
D
Douglas J. Steele
There isn't really one. There are too many factors involved: how many users,
how well designed the database is, network speed and so on.
how well designed the database is, network speed and so on.
J
Joseph Meehan
What is the largest recommend file size of a Microsoft
Access Database?
Largest possible is 1 or 2 gig depending on the version you are using.
Largest recommended is just smaller than too big. Too big is the size
where it starts to have problems. No way to really tell ahead of time far
too many factors including the environment, number of users etc.
L
Larry Linson
What is the largest recommend file
size of a Microsoft Access Database?
My colleagues have given you good answers, but I'd like to add:
You can link to multiple databases from a given database, so the 2GB size
only really limits the size of tables that have to be related (which must be
in the same database). One Access db, linked to multiple other DBs, can
access much more than 2 GB of data. (I caution that I have never done this;
every application I have worked on that was anywhere _near_ 2GB was an
Access client to a server DB for various other reasons than the size
limitation.)
Access is an excellent tool for creating "client applications" to server
databases, in which case the amount of data that can be accessed is only
limited by the capacity of the server database.
Server databases, such as Microsoft SQL Server, tend to have a distinct edge
in reliability, recoverability, and scalability. Except for Open Source
server databases (such as MySQL and PostgreSQL), they also tend to have a
per-user charge, whereas the Jet database that comes with Access, the MSDE
(aka Desktop Edition of Microsoft SQL Server) that also comes with Access,
and the "Express" edition of the new SQL Server 2005 (only available in Beta
test, at present, but sigificantly expanded specs from MSDE which it will
replace) do not have a per-user charge.
That may be more information than you need, but I hate to make limiting
assumptions that might deny someone information they _do_ need.
Larry Linson
Microsoft Access MVP