Images and Database Size

[MinnKota]

I import images and my database get larger, and understanbly so. Then I delete the image and the database stays the same size; I don't understand this.

 

[john2thompson]

I have never really user images in a database before, but suggest you try to Compact (Tools>Database Utilities>Compact Database) after removing the images.

Hope you find this helpful.

cheers,
John

 

[MinnKota]

worked great!

thanks

 

[Gazonice]

Hi,

If your database is getting large and needs compacting further you can start Access with the following command line: msaccess /decompile.

Then, open your database and it will decompile it for you. You then go to Tools / Macro / Visual Basic Editor. Choose Debug / Compile_[database_name]

This will give you a compact and faster (if you have a lot of VBA Code) database.

Note, this mostly works on larger databases.

Regards,

Garry

 

[MinnKota]

thanks for the extra bit of advice. I may end up using that down the road.