I am starting an inventory business and have written an Access(XP)DB to hold all the data as well as JPGs of the more valuable pieces. It all works well, but the JPGs in my table are HD HOGs (500K for each 30K JPG). I now see that I should keep the JPGs in a directory and link to them, but I am having a problem doing that. I am using an Unbound Object Frame and can link to a JPG file with no problem, but I can't programatically change the link to the correct JPG for the record. I am changing the value in Source Doc, but that doesn't do anything.

Nashville_Bill

__________________
Nashville_Bill

Actually the size of the database is 74,000K with the JPGs and 600K without them.

Nashville_Bill

Take a look at the Northwind database sample "Employee" form. There is a good example of calling and storing files outside the database.

Thanks jemacc, that looks perfect.

Nashville_Bill

Well, I don't understand all the code, but through copying and pasting of the controls and code I made it work and my database size is down to 260K. The database is much easier to use now also. Thanks again jemacc.

Nashville_Bill

Now that I have the form working correctly, I have a new problem. With every record, I import a new JPG, which works fine, BUT I get a message box that says: importing (followed by the path and file name)with a progress bar. This doesn't appear on the similar employees form of the Northwind database. Worse yet, if you advance to the next record quickly enough the message box will get stuck on the screen. It won't even go away when you close Access(XP) and I can't get back into the Access program until I reboot WinXP. I would love to get rid of this and even put a DoEvents in my Next Record command button, but no help.

Nashville_Bill

what version of access are you using?

Try this.

open the form in design via. close any form properties you may see including the design wizard. save the form again and see if dialog box for import appears again?