Split Database. Update linked tables if back end moved. (1 Viewer)

MatMac

Access Developer
Local time
Today, 05:43
Joined
Nov 6, 2003
Messages
140
Hi.

I'm about to move to a back end / front end system, from a single database file. Before I do so, I want to make sure I have all bases covered so to speak.

My back end file will reside on a server. I am aware that path names are sometimes changed by network administrators without warning.

From tests, I notice that, if the path to the back end can't be found, one cannot open the front end database file at all (Access 2003).

My question is: if my back end file gets moved, or the path changed, how can I get into my front end file to update the linked tables.

Many thanks in advance.

Mat.
 

Zigzag

Registered User.
Local time
Today, 05:43
Joined
Aug 19, 2007
Messages
386
Hi Mat,

Do a search for "relink access tables" by a guy called Dev Ashish.

Garry
 

Users who are viewing this thread

Top Bottom