Database Size

[Gary]

Is it much of a problem is an Access database reaches over 1 gig in size? I
can easily see the database I designed reaching that figure in a few weeks
time. Even with the compacting/repair utility I run every day.

 

[Rick B]

Depends on the version of access. Go to help and type "preferences" to see
how large a file your version will support.

If it is a problem, you may want to break data into multiple backends or
upsize to a server based database.

 

[Kevin3NF]

Unless your indexing and query deisgn is perfect, it will probably become a
problem. With that sort of growth I strongly recommend looking into SQL
Server, since Access 2000 + is limited to 2GB

--
Kevin Hill
President
3NF Consulting

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

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Douglas J Steele]

One question is why is it getting so big? Are you storing images in it? If
so, consider taking the images out of the database, and only storing a path
to them: Access is notoriously bad at handling images internally.

 

[Joseph Meehan]

Is it much of a problem is an Access database reaches over 1 gig in
size? I can easily see the database I designed reaching that figure
in a few weeks time. Even with the compacting/repair utility I run
every day.

That is a rather large database for Access. It is the limit for 97 and
prior versions.

Are you compacting the database from time to time, or are you storing
images in the database?

Even with the current versions which allow 2 gig files, that one is
rather large and you may want to consider an SQL server with an Access front
end.