Reduce database file size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have created a database including a total of 200 image files, although
images size are small 4KB for each, the database size becomes 150MB.

I tried and copacted the databse but no change.

I'm looking for any solution to reduce the file size, please help.
 
Khalid said:
Hi,

I have created a database including a total of 200 image files,
although images size are small 4KB for each, the database size
becomes 150MB.

I tried and copacted the databse but no change.

I'm looking for any solution to reduce the file size, please help.
Click to expand...

First your database can grow to 1 or 2 gig depending on the version.

Second you can use links to the files rather than placing the files in
the database.
 
I cannot give you the technical reason but I know mdb files are very bad for
storing images and other files. The mdb will bloat a great deal as you know
by now. I recommend you store a file path to your images and then store the
pictures in a folder.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does no. of tables affect database speed? 5
large database file size 1
reduce Access 2007 database size 6
large database file size after new table addition 4
Reducing Database Size 2
access file size limits 5
Why the database size does not reduce after deleted several large tables? 1
Compact and Repair doesn't reduce size anymore 2

Back
Top