Changing Linked Table Paths (1 Viewer)

I've searched quite a bit for an understandable (for me) solution to this problem. I need to be able to change, within an Access VBA macro, the path name to all linked tables. The path to all linked tables is currently something like 'G:\databasefolder\db.mdb'. I need to dynamically set this path to a UNC path like '\\hostname\drivename\databasefolder\db.mdb'.

Would appreciate a good coding example (simple I hope) or some detailed advice on how to do this.

Thanks.

Allen points to a couple here:

http://allenbrowne.com/ser-01.html

I've used the mvps code in a couple of apps.

Thanks. I'll look it over.