Locking a database

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
 
J

Joan Wild

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
How can I open a secured database? 3
Database Backend Data password 2
Record-Locking 5
Group Permission unsolicted changes 2
Is it possible to create an MDE from an Access 2000 DB with ULS 3
Linked database access 1
Problem in securing data base 1

Top