troubleshooting Question

Linking images to access database

Avatar of holdsworthbros
holdsworthbros asked on
Microsoft Access
12 Comments1 Solution546 ViewsLast Modified:
Hello Experts,
I have what I hope is a simple problem to solve in Access 2000.

I have a database that I would like to display images in. (I recently deleted all the images out of the database becuase it was getting too big).

Each record has a record ID, and all the images I want to display are stored in C:\valuations\
Not every record has an image, but all the images follow a naming format of <record ID Number>.jpg

So record 1234 has an image 1234.jpg

Is there some way I can link the image to the record to display it on the form and in the report (one record per report).
There are two outcomes I would like...

1) To be able to set up a default path to the file for each record so I dont have to manually link each file to each record. If the image is present it will automatically load.

2) To only have the image location/path stored in the database and to have it load 'as required' for viewing and printing purposes (i.e. not stored in the database).

I am a bit of an Access know-nothing so some detail would be appreciated.
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros