From: Fox on
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\WillPowerBE.mdb
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "A. Smart" <ASmart(a)discussions.microsoft.com> wrote in message
> news:4CA80BAE-EFC6-4393-B647-CCE08A929CC0(a)microsoft.com...
> > 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
>
>
>