Setting "Fixed" network drive location for Back-end DB.

[CDKrash]

YOU ARE THE BOMB!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! You saved me from pulling out all of my hair..

[RuralGuy]

That's great! So you are ready to use the Thread Tools and mark this thread as Solved, right?

[Rickyp]

If your Back End DB is on one of the Network Comuters (Computer A), Place The Front In DB on another Networked computer (Computer B). Link the Front End (Computer B) to the Backend (Computer A) tables. Copy the front end to all computers on the network, includeding a copy on the Back End computer (Computer A) and no matter what computer you place the Front End DB on, the link will always point to the Back End DB Computer where your tables exist. I hope this helps you. This is the way I always set up my network computer and I avoid having to re-link each time to the back end.

If you find the need to make progam changes to the Front End DB make sure any linking to new tables in the Back End DB is done accross the Network.

Best of Luck

Rickyp