Changing Linked Tables in code - Permissions

[vbcraft]

Hi,
I have code which changes the file path of linked tables (Front end). The
code works fine for me but when I test it with my users account settings I
get a "permission error". What permission setting do my users need in order
to make this work?
The reason I am doing this is because some users shared drive letter is
different depending on which building they're in. Real pain when trying to
link them to the tables.

 

[John Spencer]

I would guess that the permission error has to do with the users permission to
the location of the backend.

Since the shared drive letter varies, you might consider using UNC paths
(Universal Naming Convention?) to set up the links.

You can set the path using UNC by going thru the Network (My Network Places).

Instead of a path name like
J:\InfoSysDev\Information Systems\MyDataBase.mdb
you will get a path name like
\\XXX1\InfoSysDev\Information Systems\Mydatebase.mdb

With the linkage set up that way, your users won't have to worry about mapped
drives. They will still need read, write, and delete privileges on the
directory where the back-end database resides.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[sluv]

Hi,
I have code which changes the file path of linked tables (Front end). The
code works fine for me but when I test it with my users account settings I
get a "permission error". What permission setting do my users need in
order
to make this work?
The reason I am doing this is because some users shared drive letter is
different depending on which building they're in. Real pain when trying to
link them to the tables.

 

[sluv]

Hi,
I have code which changes the file path of linked tables (Front end). The
code works fine for me but when I test it with my users account settings I
get a "permission error". What permission setting do my users need in
order
to make this work?
The reason I am doing this is because some users shared drive letter is
different depending on which building they're in. Real pain when trying to
link them to the tables.

 

[vbcraft]

Thank you John.
I will try that this morning to see what results I get rather.
I would still like to know what permissions a user needs in order to modify
linked tables. Can't seem to get it to work.

Thanks for your quick response!

 

[sluv]

Hi,
I have code which changes the file path of linked tables (Front end). The
code works fine for me but when I test it with my users account settings I
get a "permission error". What permission setting do my users need in
order
to make this work?
The reason I am doing this is because some users shared drive letter is
different depending on which building they're in. Real pain when trying to
link them to the tables.