Originally Posted by
John_G
That's your issue, then. The links contain the full path, including the Drive designation - in this case C:\, so when you moved the folder UC MEXUS Library (and its subfolders) to another location, the links were no longer valid, and you have to update the links in the table. That is not as difficult as it appears; a single SQL Update statement will do it.
First, make a backup of your database, just in case (you should always be making backups anyway).
Then, you use a SQL statement something like this:
"Update tablename set linkfieldname = replace(linkfieldname,'C:\Users\Louise\Documents\', 'newpathname')"
This statement will replace all the old path names in the links with the new one, leaving the actual folder part unchanged.
Replace the names in italics with the names you use in your database.