Compressing databases

[Greg Shickle]

Hi Everyone

can anyone tell me how to reduce the size of an access
database?

we've created one here and it only contains approximately
400 observations, but does have a lot of reasonably
complex queries to it. It takes up 41mb

any way to make it smaller and hopefully as a result
quicker?

I've already tried the compress function which just
reduced it's size by 9mb#

thanks very much

Greg

 

[Bob]

You can create and MDE file which reduces the size of the
database but you should read up on MDE's before doing
so...there are some limitations and some precautions you
should follow.

41MB is pretty big for 400 observations...depending on
what's involved in one observation I guess. I have a
database with 90,000 records, each containing 20 fields,
that is only 18MB. The use of graphics in your database
will drastically enlarge the file size too.

 

[Guest]

Hi Thanks very much for your help

turns out that without the graphics the file size came
down by 40mb!

cheers again

greg