Jump to content

File Size


This topic is 5730 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am having a terrible problem. I have a very simple database which will have 2 images for every record. I have 6 records and my datbase is up to 80MB but the pictures are a maximum of 1mb each. I have not deleted any records so I can not understand where all the fat has come from. This can not be right. When I am up to 1000 records my file would be rediculously large. Is there something I can do rather than storing a reference, I used to do this in the past but always ended up with more problems than advantages.

Link to comment
Share on other sites

Images in container fields do take up a bit more space than their actual file size, but this sounds a little bit excessive. Have you previously had a lot more than 6 records with images that have since been deleted? Sometimes empty space is not reclaimed and the file is fragmented. If you use the file maintenance utility in 8 advanced or if you use save a copy as... (compressed) the file size should go down.

If you're worried about your main file getting too large, and you don't want to use references, you could create a separate file that only holds the container data and relate those records to the ones in your main file.

Link to comment
Share on other sites

This topic is 5730 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.