Relinking tables in secure database

[Adrian Jansen]

Access 2002

I have a secured database, standard Fe/Be. I set security up so that all
groups only get RWOP permissions on the queries, no access to the Be tables.
For one group of users, I want to give them the facility to relink the Be to
another database, so that they can mess around with some dummy data before
committing some of the changes to the real data. I have a form with a
command button which opens a diaog box with the file, and does the relink
from code, but it only works when I log on as owner or with Admin
permissions on the tables. What permissions do I have to give this group to
be able to do the relink ?


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Eric Butts]

Hi,

You'll find you answer in ACC2000: Microsoft Access Security FAQ Available
in Download Center

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793&Product=acc20
00


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."