Back end Front end file locations

[Guest]

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.

 

[Douglas J Steele]

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.

 

[Guest]

Thank you

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.

 

[Ron2006]

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

 

[Guest]

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.

 

[Ron2006]

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

 

[dbahooker]

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

 

[Richard]

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.