Saving OLE Linked Objects with Relative Path

[bnnook]

We want to put an access 97 DB on a DVD.

In a table OLE column, we have several hundred photos that are linked, not embedded.



The problem is, the path to these files are absolute, eg, G:\msaccess\photos\img02.jpg

Is there anyway to make the path relative like: photos\img04.jpg ?

That way, if the customer has a dvd player that used a different drive letter than we did, the links will still work?

I tried entering the links as a relative path photos\img05.jpg but access converts them to absolute paths G:\msaccess\photos\img05.jpg.

It's for an archaeology project.

[bnnook]

Moving to Access 2003 solved all our woes.