Access Imaging Seminar

Store subfolder paths in your table, and store the top-level path on a separate table.  When you move the database and/or the pictures, you only need to change the top-level path.  This is how this kind of thing is usually done.  For instance:

Store your top-level path of your pics in a separate table:

    C:\My Pictures

In your picture table, you store all your picture links as subfolder paths that look like this:

    images\pic1.jpg
    images\pic2.jpg
    images\pic3.jpg
    images\pic4.jpg
    images\pic5.jpg
    Etc.

When you move your database and/or pictures, you only need to change C:\My Pictures to whatever the new parent folder is, and don't have change anything in your picture table, as long as all the pics are stored inside the "images" subfolder.

The full path can be recreated with a simple string concatenation:   TopLevelPath & "\" & SubfolderPath

Thanks Kevin.  Still a bit complicated.  I have seen other software, such as some CAD programs, where you keep all the files under one folder and you can move that folder within the same computer, or move to another computer, and the links are maintained, which makes it very practical. No need to worry about the Top Level Path.

It's not complicated to make a table with just one field, one row, and store the top-level path in it, and update it accordingly.  You can ask the makers of those CAD programs how they do it.  If they can magically read your mind about where you store your files, their method is undoubtedly a lot more complicated than mine.  Most programs store file paths via INI files, Windows registry, environmental variables, user settings (like web browsers that let users specify download folder path), things of that nature.  And that is basically the same method as what I suggested.