Linking tables by local reference?

[Sprocket]

Hi All,

Is it possible to link tables that are in different databases that are in the same folder on a shared drive using the old fashioned "dot" syntax that used to be used in DOS. You remember .\..\ etc. and if so how. UNC referencing won't work here because....

What I have are several small databases that pull some of their information from a master database and add to it. They do not store the results as static data because I need it all to be dynamic, hence the use of a linked table. However, at the end of each year I need to take a snapshot (burned onto CD) for archiving. The way I thought I would do this is to set up the links to reference the tables as files in the current folder so that I can just copy the folder to CD. The problem is that the linked table manager demands a drive letter so the copy tries to go to the live version and not the version on CD.

I have read Pat Hartmans advice on how to enter UNC addresses and have tried to enter my link as ..\filename but it will not accept this.

Is it possible to link files as local references this way? If so How?


Many thanks in anticipation..........Sprocket

 

[ByteMyzer]

Access does not allow relative mapping. You can use absolute mapping, either referencing mapped drives or UNC paths.

 

[Pat Hartman]

You can add code to your db so that it searches for the linked tables on open and if they're not found, prompts for their new location. You can find examples in solutions.mdb and by searching here.