Consulting

Results 1 to 2 of 2

Thread: making tables invisible/ locking users out of database forms/tables/queries/etc

  1. #1

    making tables invisible/ locking users out of database forms/tables/queries/etc

    I need to lock a nosy user out of the tables on a database. This is a front end/back end application. I can lock the users out of the tables in the front end, but forget how to lock everyone out of the back end.
    I know it's a simple solution but haven't had the need to do this in a decade. Now I forget how to do it.

    Any suggestions?

  2. #2
    VBAX Tutor
    Joined
    Mar 2014
    Posts
    210
    Location
    you could set the properties of the BE file , and remove all his rights.
    But if he still needs to use it, AND he knows the path to the backend, I dont know how you stop him besides tattling.
    I have a table ,tUsers , of those allowed in. When the app starts, it checks the list to see if they can be in.
    If so, i Hide the tables.
      DoCmd.SelectObject acTable, , True
      DoCmd.RunCommand acCmdWindowHide
    of course this could be byPassed with the shift key if they know that trick,
    so then you must disable that!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •