Does anyone know of a way to restrict folks from having access to a DB's tables and queries? I have installed my own version of User Level Security and compiled the DB into an *.mde file but that does not stop someone from creating a blank DB and importing my tables and queries. It appears that the *.mde file protects everything that has some sort of code attached to it. If this is the answer I am not aware of any way to attach code to a table or query.

Any answers or ideas here would be greatly appreciated.

Kenny Alligood

__________________
Kenny Alligood

Have you wiped off every privelidge from the inbuild "Admin" account? If not - do that immediately.

Another way you can do it - and this is a bit of a massive task - not a quick fix at all - is to use RWOP - there's a few details about it in the Access Security FAQ
http://support.microsoft.com/default...b;en-us;165009

and more I think there's more info in the Access Developer's Handbook (Volume II) ( I don't have the book on me at the minute).

But if you don't let the "admin" do anything at all - and I mean - not even open the database - then you should probably be ok

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends

One quick note if you do that Kenny: make sure you make a backup incase the privileges are not set correctly and you cannot get back in.

That probably goes without saying but I wanted to make sure we avoid seeing another post asking how you get into a locked DB!




-Shay Shepston