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.