By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

Handling Linked tables

P: n/a
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.
Nov 15 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 15 Nov 2007 04:41:46 -0800 (PST), re*********@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.
Nov 15 '07 #2

P: n/a
<re*********@hotmail.comwrote in message
news:f0**********************************@c29g2000 hsa.googlegroups.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

Nov 15 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.