Changing Embedded to Linked - Reduce File size

[Ngan Bui]

Have you compacted the db since changing it? That should
reduce the size.

>-----Original Message-----
>Hello.
>
>I recently did a test to review how the file size would
>change in my database if I made all of my "background"
>images in my forms embedded instead of linked. They were
>originally added by using a custom "auto-format".
>
>The file size of my database increased by 40 MB. Because
>this was not an acceptable change, I went back and

changed

>them back to linked images. In retrospect, I should have
>changed the auto-format and reapplied it to all of the
>forms, but this is not how I did it. I changed it in

both

>instances in the property settings for the background
>image.
>
>Now, however, the file size has not gone back down. It

is

>still 40 MBs larger than it originally was.
>
>Is there some code hanging somewhere retaining those
>images even though I changed them to linked images?
>
>Any help would be appreciated.
>
>Thank you.
>
>- Sharyl
>.
>

[Sharyl]

Thank you! It worked perfectly.

- Sharyl

>-----Original Message-----
>Have you compacted the db since changing it? That should
>reduce the size.

>>-----Original Message-----
>>Hello.
>>
>>I recently did a test to review how the file size would
>>change in my database if I made all of my "background"
>>images in my forms embedded instead of linked. They

were

>>originally added by using a custom "auto-format".
>>
>>The file size of my database increased by 40 MB.

Because

>>this was not an acceptable change, I went back and

>changed

>>them back to linked images. In retrospect, I should

have

>>changed the auto-format and reapplied it to all of the
>>forms, but this is not how I did it. I changed it in

>both

>>instances in the property settings for the background
>>image.
>>
>>Now, however, the file size has not gone back down. It

>is

>>still 40 MBs larger than it originally was.
>>
>>Is there some code hanging somewhere retaining those
>>images even though I changed them to linked images?
>>
>>Any help would be appreciated.
>>
>>Thank you.
>>
>>- Sharyl
>>.
>>

>.
>

[Unregistered]

make sure to compact database on exit - this will fix it - or just run compact and repair