Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Storing tiff images

Posted on 2003-03-05
Medium Priority
Last Modified: 2012-08-14
How can I get to store tiff images in a field of my database.
Question by:prosperkach
  • 2

Expert Comment

ID: 8071741
Hi Prosperkach,

You want to use an "OLE Object" data type for a field in your table. So if you go into design mode within the table and add a field (or edit an existing field) and choose the "OLE Object" as the data type you will actually be able to store the tif image within the database.

I hope that this helps.

LVL 41

Accepted Solution

shanesuebsahakarn earned 300 total points
ID: 8071774
I do not recommend storing images directly in a database. It will cause your database to expand in size dramatically. You are best off storing the image's file path in a text field. When you need to display it, you can use a linked Image control and set its .Picture property to the file path.

Expert Comment

ID: 8071956
I would agree. If you are storing a lot of images the OLE object won't work well for you. However, if it is only a few images then you're fine. Essentially, look at the file sizes of the images you are storing and multiply it by the number of images you are envisioning for the entire database and you have a sense of how big your database will become.

If it is going to be too big then I like shanesuebsahakarn's idea.


Author Comment

ID: 8077942
Thanks a lot,

Your advise has really done wonders.

thanks again

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question