Form background, incredible size

[spikey]

Hi all,

I tried to insert a pictere to a form via its main properties, so i can use it as background. Everything went well, it looks very nice , except the database-size increased with 5MB per form and opening/saving of the form runs very slowly. The picture is only 25 kb. when i delete the background from the form the size stays unchanged! How is this possible and how can i insert a background without perfomance (in size and speed) decline?

Kind regards,

tim

 

[Mile-O]

If you must have graphics in your database then the first tip is not to actually enclose them within the database but to link to them.

Images have a property (I forget its name) that lets you flick between whether the image is Embedded or Linked. Embedded sticks it into your database and drives up the overall file size. If it's used in numerous forms then each form has their own copy of the graphic. Linking tells the form where to get the image and finds it (via its path) and puts it where you've specified. The larger the graphic, of course, the bigger your database size will become. The larger the graphic, also, the slower your database will run as it paints the graphic to the screen with each instance.

So, keep to a minimum of graphics and keep them small. If you want a graphic to fill the complete form background then it's advised to usse a small image that will tesselate via the Tiled property.

When you remove objects from Access the space they use up is not reclaimed until you Compact your database. Goto Tools -> Compact and your database will be compacted.

Databases in development "bloat" as objects are added and deleted during the process. During this time it's advised to comapct regularly.

 

[spikey]

Thnx for your clear reaction.

regards,

Tim