Database splitter reference??

[Rajesh Candamourty]

Hi to all,

I have a database splitted using a splitter wizard. It works fine for the
multi user environment. My master database resides on a network and each
user has the front end copied to their desktop.
After having done with different conditions, I am curious to know how does
access know that the master file resides over the network (here J: Drive),
how does it keep its reference?
I have even tried copying both the front-end and back-end files to the
desktop and deleting the master one in the network, it wouldn't run and
throws an error - J: \...\....mdb, check the path?
I am interested to know, how it keeps its reference and how does it tracks
the link.

Any help will be greatly appreciated.

Thank you.

- Rajesh Candamourty

 

[Roger Carlson]

The connection string is stored in the linked table object. If you open
the table in Design View (Yes, I know will complain. Do it anyway.) Then
click the Properties button, you will find the connection string. It will
be hard-coded with the path and file name you orginally linked it to. In
order to change this, you must use the Linked Table Manager or create your
own code to re-link them.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L