Locking a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access2000 application with 3 linked databases (tables only). I am
trying to lock the application down so users who have full MS Access
installed cannot get to the data by going into the database window and
opening any table(i.e. they should only be able to view data via forms), this
is because the database contains settings for many other users and should be
private.

Each linked database has a password applied but the data is available in the
main application as you have to provide the password when initially linking

Setting an workgroup file does not work as you either give permission to
read data or not at user level

An MDE only locks down the code

does any body have any thoughts on this

regards
 
You can use Run With Owner Permissions (RWOP) queries for all data
interaction and remove all permissions on the tables.
 
Hi Lynn

Thanks for this, the by pass key works perfectly but by pressing F11 it is
still possible to raise the database windows, what do you mean by 'hide'

Regards

sabrina
 
Back
Top