Prevent users from opening BE

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

Guest

Hi
I have a split database where both FE and BE is secured, and that works fine
Some users tend to open the back end directly, and thereby seeing all the tables - which they shouldn'n
In that way they skip all the user interface forms..
Is there a way of preventing them from opening the BE - whitout denying them to link to the tables via the front end

Help would be gratly appreciated
Ingrid
 
If they can open the BE directly then you haven't properly secured
everything. Get a copy of the Security FAQ and follow it to the letter. As
an added piece of info, you can store the BE in a hidden folder and your
users will not likely be able to find it any more.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Ingrid said:
Hi!
I have a split database where both FE and BE is secured, and that works fine.
Some users tend to open the back end directly, and thereby seeing all the tables - which they shouldn'n.
In that way they skip all the user interface forms...
Is there a way of preventing them from opening the BE - whitout denying
Click to expand...
them to link to the tables via the front end?
 
Thanks for the response
Can I set 'no' to open/run the BE database, and the users will still be able to access the linked tables in the FE
I thought not...
Ingri

----- Lynn Trapp wrote: ----

If they can open the BE directly then you haven't properly secure
everything. Get a copy of the Security FAQ and follow it to the letter. A
an added piece of info, you can store the BE in a hidden folder and you
users will not likely be able to find it any more

--
Lynn Trap
MS Access MV
www.ltcomputerdesigns.co
Access Security: www.ltcomputerdesigns.com/Security.ht


Ingrid said:
Hi
I have a split database where both FE and BE is secured, and that work fine
Some users tend to open the back end directly, and thereby seeing all th tables - which they shouldn'n
In that way they skip all the user interface forms..
Is there a way of preventing them from opening the BE - whitout denyin
Click to expand...
them to link to the tables via the front end
 
I generally make a small start-up form in the back end that informs the user
they don't have permissions. When they click ok to the message...I do a:

application.Quit

The users think it is some security issue. If I disable the shift key
by-pass, the this little trick generally keeps people out of the back
end...AND NO security is needed.

For the front end, you no doubt distribute a mde, and once again if you use
the tools->start-up options, you can complete hide and keep people
completely out of the ms-access interface. This feature again can also be
done AND NO security is needed.

So, to protect both parts...you generally can get away with not having to
use security.

If you want to try an example of a file that has the ms-access interface
hidden..try downloading and running the 3rd example at:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
 
Back
Top