I intend to place the back end file in a shared folder on our network. When
I use the database splitter wizard I also save the front end file there.

Will the links still be Ok if the user moves the front end file into one of
their own folders which are not shared.

It depends on how the link is made.

If the front-end was linked to the back-end using mapped drives, the user
must have the same mapped drive. If he/she does have the same mapped drive,
there should be no problem.

If the front-end was linked to the back-end using a UNC (\\server\share),
there should be no problem.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Mary Ann" <(E-Mail Removed)> wrote in message
news:5EAFF54D-78C2-424D-A119-(E-Mail Removed)...
> I intend to place the back end file in a shared folder on our network.
When
> I use the database splitter wizard I also save the front end file there.
>
> Will the links still be Ok if the user moves the front end file into one
of
> their own folders which are not shared.

Thank you

"Douglas J Steele" wrote:

> It depends on how the link is made.
>
> If the front-end was linked to the back-end using mapped drives, the user
> must have the same mapped drive. If he/she does have the same mapped drive,
> there should be no problem.
>
> If the front-end was linked to the back-end using a UNC (\\server\share),
> there should be no problem.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Mary Ann" <(E-Mail Removed)> wrote in message
> news:5EAFF54D-78C2-424D-A119-(E-Mail Removed)...
> > I intend to place the back end file in a shared folder on our network.
> When
> > I use the database splitter wizard I also save the front end file there.
> >
> > Will the links still be Ok if the user moves the front end file into one
> of
> > their own folders which are not shared.
>
>
>

Word of caution.......


If you are doing importing / exporting of files, AND you coded those
operations looking at the local drive or the C: drive then you
will/may have problems.

Ron

How can I force the link to use //server/share instead of mapped network
drive. I have multiple users that need to use the database, but I can't
guarantee, nor require, that they all use the same drive mapping...

Thanks.

"Douglas J Steele" wrote:

> It depends on how the link is made.
>
> If the front-end was linked to the back-end using mapped drives, the user
> must have the same mapped drive. If he/she does have the same mapped drive,
> there should be no problem.
>
> If the front-end was linked to the back-end using a UNC (\\server\share),
> there should be no problem.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Mary Ann" <(E-Mail Removed)> wrote in message
> news:5EAFF54D-78C2-424D-A119-(E-Mail Removed)...
> > I intend to place the back end file in a shared folder on our network.
> When
> > I use the database splitter wizard I also save the front end file there.
> >
> > Will the links still be Ok if the user moves the front end file into one
> of
> > their own folders which are not shared.
>
>
>

When you establish the link in the link table manager, enter(type in)
the //server/share part of the location when you start to look for the
mdb. Once that is there it will keep it and maintain it for the link
process.

Typically it starts on your C drive, just type in the //server/share
part and it will take over from there.

Ron

keep your data in SQL Server.. if you use Access Data Projects; this is
a lot easier to manage.. because you don't need to move 2 mapped files
around

ADP just has this single connection to SQL Server; it's a lot easier to
manage

-Aaron




Ron2006 wrote:
> When you establish the link in the link table manager, enter(type in)
> the //server/share part of the location when you start to look for the
> mdb. Once that is there it will keep it and maintain it for the link
> process.
>
> Typically it starts on your C drive, just type in the //server/share
> part and it will take over from there.
>
> Ron

"Douglas J Steele" wrote:

> It depends on how the link is made.
>
> If the front-end was linked to the back-end using mapped drives, the user
> must have the same mapped drive. If he/she does have the same mapped drive,
> there should be no problem.
>
> If the front-end was linked to the back-end using a UNC (\\server\share),
> there should be no problem.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Mary Ann" <(E-Mail Removed)> wrote in message
> news:5EAFF54D-78C2-424D-A119-(E-Mail Removed)...
> > I intend to place the back end file in a shared folder on our network.
> When
> > I use the database splitter wizard I also save the front end file there.
> >
> > Will the links still be Ok if the user moves the front end file into one
> of
> > their own folders which are not shared.
>
>
>