Handling Linked tables

Hi all, can anyone help me with this one?

I have a database that has multiple linked tables and i want some code
to tell the database on startup to do first check for the tables in a
folder on one drive, and if not present to get them from another.

This is because my application is on a newtork and IT have a habit of
changing the drive letter, which means that one day the linked tables
all work fine, the next day it can't find them and i constantly have
to re-link the tables each morning so a piece of code on startup would
solve the problem, trouble is i don't know where to start.

I have found Dev's code to 'Relink Access tables from code', and its
not working for me, what i'm after is i want it to run in the
backgroundand only tell me if it failed to find any of the tables.

Any advice much appreciated.

Re: Handling Linked tables

On Thu, 15 Nov 2007 04:41:46 -0800 (PST), redpears007@hotmail.com
wrote:

Use UNC paths rather than drive letters.
\\someserver\someshare\the.mdb

-Tom.


>Hi all, can anyone help me with this one?
>
>I have a database that has multiple linked tables and i want some code
>to tell the database on startup to do first check for the tables in a
>folder on one drive, and if not present to get them from another.
>
>This is because my application is on a newtork and IT have a habit of
>changing the drive letter, which means that one day the linked tables
>all work fine, the next day it can't find them and i constantly have
>to re-link the tables each morning so a piece of code on startup would
>solve the problem, trouble is i don't know where to start.
>
>I have found Dev's code to 'Relink Access tables from code', and its
>not working for me, what i'm after is i want it to run in the
>backgroundand only tell me if it failed to find any of the tables.
>
>Any advice much appreciated.

Re: Handling Linked tables

wrote in message
news:f0d0c695-7f9f-487c-8610-808937be7d14@c29g2000hsa.google groups.com...
> Hi all, can anyone help me with this one?
>
> I have a database that has multiple linked tables and i want some code
> to tell the database on startup to do first check for the tables in a
> folder on one drive, and if not present to get them from another.
>
> This is because my application is on a newtork and IT have a habit of
> changing the drive letter, which means that one day the linked tables
> all work fine, the next day it can't find them and i constantly have
> to re-link the tables each morning so a piece of code on startup would
> solve the problem, trouble is i don't know where to start.
>
> I have found Dev's code to 'Relink Access tables from code', and its
> not working for me, what i'm after is i want it to run in the
> backgroundand only tell me if it failed to find any of the tables.
>
> Any advice much appreciated.

Try using \\ServerName\ShareName\Folder instead of a drive letter.

Keith.
www.keithwilby.com