Split Database with Not Valid Path Problems

[Kozbot]

Hello

I am attempting to split an Access 2007 database. My company has two locations. From my location we are remote connecting into the server. While down there they are connecting directly. When I split the database, people in my location can use it fine. When people down there use it, they get a not valid path error.

This is because the network drives are mapped differently. I have been reading that the solution is to use the UNC for the back end file path.

Can anyone give me, a guy who is non IT, instructions on how to do this?

 

[namliam]

On your mapped drive you will see something like:
Project (\\SomeServer) (P:)

The normal drive path starts with P:\...
The UNC path will start with \\Someserver\Project

Sometimes you are mapped to a "deeper" share in which case it will look like
Project (\\SomeServer\Public) (P:)
In which case the UNC is \\SomeServer\Public\Project