Hi all,

I have a front-end database with a linked (data) database. Problems arise when this goes onto other PC's on different directories and I get the error that it can't find the linked database. This is easily fixed by updating with the linked table manager, but as I am not sure which directories the database will be run from on other PC's, is there a solution that easily updates the linked tables? (the two database files will always be in the same folder). I realise that if I can identify a common directory that can be used on all potential PC's, then this problem can be avoided, but I can't guarantee this.

Thanks in advance,

Atholl

I presume you mean you have a front end, backend arrangement. If that is the case then I think this database provided by Roger Carlson (http://www.rogersaccesslibrary.com/TableOfContents3.asp#L) may have the functionality you are looking for. I have not used it myself or studied it so please advise if I have misled you.