BackEnd Security for linked files 1

[cschnable]

I am building an Access application with a backend Access db and I cannot get the tables to link unless I give the users group administration rights on the tables. Does anyone know of a way around this, because I don't want everyone have administrative rights to the tables.

Thanks for any help you can give me

 

[Francescina]

Relinking of tables requires administrator rights on the frontend. The only workaround that I know (and extensively use) is in creating a special admin who is "locked" (the currentuser is always checked on opening the app) in a certain form (allowing only to relinke the tables, nothing else). This form can not be left without closing ACCESS.

 

[cschnable]

Francescina -
Not quit sure what you mean by having the special Admin "Locked".

The way it looks now I am going to do away with the backend db. The tough security problems outweigh the niceties of having the backend.

 

[Francescina]

How to lock an "admin" in a form:

1.) Open the frmPrison only for the certain user:

if currentuser="LimitedAdmin" then
docmd.openform "frmPrison"
end if

2.) Quit ACCESS on Form_unload:
application.quit

3.) Design the form as popup/modal etc. and block the possibility to minimize/resize etc.

You just have to experiment a little bit with it, you will see that it is not too difficult.
frmPrison can contain the code for relinking as well as the code for custom user maintenance.