MS Access database, error message Can't open file.

Hewlett-packard / P6310y
October 16, 2014 at 13:56:04
Specs: Windows 8.1 (64-bit), 6 GB
I have an Access Database which includes an input form displaying images as well as data. The data is stored in one table and the images are stored in another table with the images being linked to the data. I deleted one of the images from that table. It is not referenced in the data table either. However, every time I open this database, I get an error message that says: "Microsoft Access can't open the file. 'C:\Models\Images\HPIM2175.jpg." How can I get rid of this??? TIA!

See More: MS Access database, error message Cant open file.

October 17, 2014 at 04:18:21
Open the form in Design view and delete the link to the jpg

Report •

October 17, 2014 at 14:43:07
Thank you, beachyhbt. I tried what you suggested, however, I'm note clear on exactly what you are describing. On my form is an 'imageFrame." In this, the 'picture type' is "linked." I created this database a long time ago, but as I recall, I linked all the pictures that were to display as opposed to embedding them in order to keep the database from being so overly bloated. I have a table that stores the data. I have all the pictures in a folder. On the form, the text box links the images to show on the form by following the path listed in that field in the table. Example: C\:Models\Images. I have deleted the image that the error message is saying it can't open from the folder of images. It is no longer linked to any data in the table. I even completely deleted it from my computer. I'm not understanding how it can give me an error for something no longer in existence. If I delete the 'link' in the imageFrame on the form, it will sever all my links for the images to display. How do I single out just this one? (btw, I created this database in Access 2003 but am now using Access 2013.) Thanks again!

message edited by SweenCat

Report •
Related Solutions

Ask Question