View Single Post
  #3 (permalink)  
Old November 22nd, 2006, 08:49 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

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.


Reply With Quote