Please Help?? Split Database - Refering to backend

A. Smart · External Since: Sep 08, 2005 Posts: 37

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

Duane Hookom · External Since: Oct 06, 2004 Posts: 3853

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.DeleteThis@discussions.microsoft.com> wrote in message
news:4CA80BAE-EFC6-4393-B647-CCE08A929CC0@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

A. Smart · External Since: Sep 08, 2005 Posts: 37

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

"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.DeleteThis@discussions.microsoft.com> wrote in message
> news:4CA80BAE-EFC6-4393-B647-CCE08A929CC0@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
>
>
>

A. Smart · External Since: Sep 08, 2005 Posts: 37

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

--
Regards

Ashley Smart

"A. Smart" wrote:

> 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
>
>
> "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.TakeThisOut@discussions.microsoft.com> wrote in message
> > news:4CA80BAE-EFC6-4393-B647-CCE08A929CC0@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
> >
> >
> >

Fox · External Since: Oct 04, 2009 Posts: 1

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.DeleteThis@discussions.microsoft.com> wrote in message
> news:4CA80BAE-EFC6-4393-B647-CCE08A929CC0@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
>
>
>