Storing tiff images

How can I get to store tiff images in a field of my database.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.

prosperkachAuthor Commented:
Thanks a lot,

Your advise has really done wonders.

thanks again
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.