Please Help?? Split Database - Refering to backend

[A. Smart]

Good Afternoon,

Is there a way of changing the path that the front end of a database uses to
locate the back end? Basically I am having trouble because on some PC's the
path to the backend is different due to naff network mapping......
Thanx in advance

 

[Duane Hookom]

There is a linked table manager in the Tools menu that allows you to relink
your tables. As an alternative, when you link, you can use the UNC path
like: \\swanky\H$\Documents\Projects\Access\Garvey\WillPowerBE.mdb

 

[A. Smart]

I have actually used the UNC path for all tables apart from one, odd! And
that is my Switchboard how do I change it?
--
Regards

Ashley Smart

There is a linked table manager in the Tools menu that allows you to relink
your tables. As an alternative, when you link, you can use the UNC path
like: \\swanky\H$\Documents\Projects\Access\Garvey\WillPowerBE.mdb

 

[A. Smart]

Sorry, I'm getting lazy asking all these questions. Pretty simple really.....
Cheers

--
Regards

Ashley Smart

I have actually used the UNC path for all tables apart from one, odd! And
that is my Switchboard how do I change it?

 

[Fox]

Duane,
I want to split my db for other reason than to share with tons of people and
I want the backend on the local machine. The db front and backend will be
distributed as a packaged solution to a singler user. The user will install
the access runtime as well as the db's.
When I try to split the db called My Jewelry Project and place the backend
in a folder called My Jewelry Data using this address //My Document/My
Jewelry Data/JeweryData.accdb
it will not find the location....even though the folder exists....

I've tried ~/bla bla bla and ~//bla bla bla and these links do not work
either.

So how do I split a db and have the backend on the same computer with a
relative path?
Thanks,
Janet
--
Foxy

There is a linked table manager in the Tools menu that allows you to relink
your tables. As an alternative, when you link, you can use the UNC path
like: \\swanky\H$\Documents\Projects\Access\Garvey\WillPowerBE.mdb