UNC settings

  • Thread starter Thread starter Duncan Dimech
  • Start date Start date
D

Duncan Dimech

Dear All,
I have an Access XP database, with Access XP frontend. Both parts are saved
as MDE. I normally use drive mapping but I want to change to UNC as this
will offer more advantages. The problem is that I do not have the same UNC
(//server/directory/db.mde) as my clients.

How can I set the UNC to vary according to the client without letting the
client to mess around and without loosing the permissions set on the linked
tables?

Thanks
Duncan Dimech
EXOR Group
 
I have an Access XP database, with Access XP frontend. Both parts are saved
as MDE. I normally use drive mapping but I want to change to UNC as this
will offer more advantages. The problem is that I do not have the same UNC
(//server/directory/db.mde) as my clients.

How can I set the UNC to vary according to the client without letting the
client to mess around and without loosing the permissions set on the linked
tables?
Click to expand...

You can run code in the your startup form or from an Autoexec macro to do a
"Dir()" on each of the two UNC values and, depending on which exists, relink to
the existing location using a modified version of code available at the
following page at The Access Web (you will need to perform the modifications
yourself):

Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm
 
Thanks for the Info. I would like to ask if the permissions set will be
kept or not?

Duncan
 
Thanks for the Info. I would like to ask if the permissions set will be
kept or not?
Click to expand...

Is this application secured? If so, users should have *full* permissions to the
table *links* - you need to secure the back-end separately. See the Access
Security FAQ for more details on this. If you don't have a copy, you can obtain
one at:

http://support.microsoft.com/default.aspx?kbid=207793

If you mean permissions to the directory in which the back-end file is situated,
that is a networking issue and is dependent on the user's login.

Just a note: there is no benefit to converting a back-end data file to an MDE
file. Such a conversion only affects objects that can contain VBA code. Tables
are not VBA module enabled.
 
Back
Top