Locking down an MS Access backend


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Locking down an MS Access backend

Hybrid View

  1. #1
    Join Date
    Feb 2005
    Posts
    9

    Locking down an MS Access backend

    Hello all.

    First post on this forum, so go easy on me, yeah?

    I'm working on an access database for my employer, and I'm trying to lock it down so that users have to go through the frontend (it's been split), with the backend closing on everybody but the administrator.

    I think I've found a way to do it with macros, except for one tiny little problem. I can get the macro to evaluate if a user is an administrator, using conditions, but I can't figure out how to say "If user IS NOT administrator." Only "if user IS administrator." Is there a way to make a macro check if something is not true, so I can say "If user is not administrator, quit MS Access?"

    Thanks a bunch.

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    An administrator in the Access database or an administrator in the network domain?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Jun 2004
    Location
    Houston area
    Posts
    557
    Whatever you're using as a condition to define "administrator", follow it with [something] <> "administrator" and the action would be "Quit".
    A balanced diet is a cookie in each hand.

  4. #4
    Join Date
    Feb 2005
    Posts
    9
    pclement: It would be an administrator in the database.

    Laurel: That looks like just about what I need. I will give it a go ASAP.

    Thanks, both of you! Much obliged!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center