I have taken over a database that currently has no security assigned to it at all. The users know how exit forms and apply data directly to tables, a very bad thing. I am looking for a quick and dirty way to stop this process from happening while I design a new database with more security and eliminate this process from happening in the future. Any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hiding tables from users
- Thread starter Sully38
- Start date
Slap them.
Nothing is quick and dirty when the user has full rights to the database. My guess is that ever user has a copy of MS Access installed on their local machines. This allows each and every user admin rights... which can't be controlled "quick and dirty".
The quickest way of limiting the users access is to convert your .mdb to .mde and tell the users they must use that instead of the .mdb
Converting to .mde does not alter your database. It compiles the code and locks out the user from having unrestricted access.
Also, educating your users on why they shouldn't bypass the forms, etc., can sometimes help.
Nothing is quick and dirty when the user has full rights to the database. My guess is that ever user has a copy of MS Access installed on their local machines. This allows each and every user admin rights... which can't be controlled "quick and dirty".
The quickest way of limiting the users access is to convert your .mdb to .mde and tell the users they must use that instead of the .mdb
Converting to .mde does not alter your database. It compiles the code and locks out the user from having unrestricted access.
Also, educating your users on why they shouldn't bypass the forms, etc., can sometimes help.
Upvote
0
VicRauch
Well-known Member
- Joined
- Mar 23, 2006
- Messages
- 2,032
Do you users know that pressing F11 will display the database window? If not, you can hide it with Tools/Startup.../ then uncheck the "Display Database Window." For a little more security, you can also uncheck the "Use Access Special Keys." That way they can not even press the F11 key and see the database window.
That is the quick and dirty way to hide tables from your users.
If you need more than this, ask again and we can go much deeper.
That is the quick and dirty way to hide tables from your users.
If you need more than this, ask again and we can go much deeper.
Upvote
0
Securing tables
Creating .mde was my first thought and I wish it was that easy. But part of the reason I have taken over this DB is that there are some sections of code that got previous "Admin" over their head. So when I try to create the .mde file I get error messages. Which basically leaves me at the slapping stage.
Creating .mde was my first thought and I wish it was that easy. But part of the reason I have taken over this DB is that there are some sections of code that got previous "Admin" over their head. So when I try to create the .mde file I get error messages. Which basically leaves me at the slapping stage.
Upvote
0
Re: Securing tables
ah.... then, slap them twice.
If your current .mdb works, without errors, creating an .mde should also. The mde conversion simply (more to it than this) compiles the forms, reports, queries and VBA... before use... whereas an mdb has to compile each upon use.... so, end result is no difference beyond what I've already explained.
ah.... then, slap them twice.
If your current .mdb works, without errors, creating an .mde should also. The mde conversion simply (more to it than this) compiles the forms, reports, queries and VBA... before use... whereas an mdb has to compile each upon use.... so, end result is no difference beyond what I've already explained.
Upvote
0
Similar threads
- Question
- Question
