View Single Post
  #5  
Old October 4th, 2009, 04:41 PM posted to microsoft.public.access.tablesdbdesign
fox
external usenet poster
 
Posts: 65
Default Please Help?? Split Database - Refering to backend

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


"Duane Hookom" wrote:

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\WillP owerBE.mdb

--
Duane Hookom
MS Access MVP
--

"A. Smart" wrote in message
...
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
--
Regards

Ashley Smart