Split Database Question (Can i apply a network path to the back end) (1 Viewer)

[homer2002]

hi,

I'm in the process of creating a split database.
However the company i work for seems to run a policy of "choose your own drive letter", so it's very hard to send out front ends as they will amost surly have a different drive letter to the person sitting next to them.

Is there a way that I can point the front end of a database to the network path of the back end, so they don't need a drive letter.

I'm sure I have seen this done, i just don't know how.


any help would be greatly recieved

 

[John.Woody]

A more stable way might be to put the full network path in, not relying on mapped drive letters at all. i.e. \\PCname\Folder\File.mdb

HTH
John

 

[homer2002]

How do i do this?

when I split the database i just put the back end somewhere and don't know where to change the paths.

 

[Pat Hartman]

Move the back end to its permanent home. Move the front end to its permanent home. Open the fe and use the linked table manager to relink the tables. When the wizard opens, click the box that says to always prompt for a new location. Select all the linked tables. Then when you get the common file dialog, type the complete UNC name into the file field.