p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Compressing Picyures (http://p2p.wrox.com/showthread.php?t=50610)

Brendan Bartley November 22nd, 2006 06:46 AM

Compressing Picyures
 
Hi
I have a access database that I have added images .The problem is the database runs very slow when opening etc .Is there anything I can do to compress the images. The images are from word .rtf documents
Thanks

Brendan Bartley

leehambly November 22nd, 2006 07:49 AM

Brendan,

I'm no great expert on storing objects in databases, but this is mainly due to the fact that it is not an advisable thing to do, if you can get away with it. I only use images on forms and reports, and then linked rather than embedded if I can.

Can the images be saved as individual documents and then you simply store the file path? This means no bloating issues.

Food for thought, hope it helps...

Lee

mmcdonal November 22nd, 2006 08:49 AM

When you say you "have added images," are they graphics for your forms and reports, or are they data being stored in a table?

If they are graphics, use .jpg or .gif, and try to make them as close to their finished size as possible outside of the database, and then after you are done designing, make sure you compact andrepair the database - that is always a good idea during development anyway and can shrink the database many orders of magnitude during development.

If they are data, leehambly is right, not advisable. Access isn't a good platform for storing images. You might try SQL Express 2005, or SQL Server for image storage. However, using a linked image (which you can still display on your forms) is a better bet, IF all your users can map to the same folder. I use this method but it is somewhat kludgy. Another solution is SharePoint, which is also a SQL Server, but you can link to a web page and mapping is not so much of an issue - just DNS entries...

If you want help with displaying linked images in forms, let me know.

HTH

mmcdonal

gigaboy November 22nd, 2006 03:59 PM

more of the same...

1)maybe put them in a different database and only open when needed?
2)use to compress database utility tools/db utilities /compact and repair db
3)i know sql server there was a way to convert to binary, dont know if access has that function, will look into it later

cheers
scott


All times are GMT -4. The time now is 06:13 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.