Re: How to secure an Access database.

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 05/16/04

  • Next message: Larry Woods: "Command won't execute this SP correctly (?)" 
    Date: Sun, 16 May 2004 07:09:43 -0400

    To learn how to secure an Access database, check out the Access Security FAQ
    at
    http://support.microsoft.com/support/access/content/secfaq.asp

    My advice is to read the entire document thoroughly several times, do not
    skip any steps, and practise on a copy of the database, just in case.

    If you need additional advice, there's a group dedicated specifically to
    Access security questions:
    microsoft.public.access.security 

    -- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"robher" <anonymous@discussions.microsoft.com> wrote in message
news:49A7EAB0-3BF6-4744-BF18-74AF9AAF3EFB@microsoft.com...
> I'm building a database application with a Visual Basic 6.0 frontend and
an Access database using ADO.
>
> As a security measure, I'd like to make sure that users can only access
the database through the frontend. To achieve that, I've put the DB in a
folder that can only be accessed by a one user: "dbuser" (created
specifically for the application). I use the Windows API function
"CreateProcessWithLogonW" to run the application as "dbuser". This way,
users have no access to the MDB file but the application does.
Unfortunately, this poses some problems because other parts of the program
need to be executed with the users' permissions.
>
> What I'd like to do is become "dbuser" to open the DB connection and then
go back to the regular user. I've searched all over the web, but can't find
a way to do this.
>
> Any ideas?
>
> Or maybe I'm just going about this the wrong way. If there's a better way
to secure Access databases I'm open to suggestions.
>
> Regards,
> Roberto
  • Next message: Larry Woods: "Command won't execute this SP correctly (?)"

    Relevant Pages

    • Re: Prompted for User ID and Password
      ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... >>when I attempt to open any other Access database I'm ...
      (microsoft.public.access.security)
    • Re: Setting Access security
      ... very carefully and read it multiple time. ... them up in the Access Security newsgroup. ... Access Database Samples: www.rogersaccesslibrary.com ... Once I upload it on to the office network, ...
      (microsoft.public.access.formscoding)
    • Re: Is it possible to run a MS Access database without having Access .
      ... Lynn Trapp ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... > My boss wants me to create a MS Access database but he wants our client to ...
      (microsoft.public.access.tablesdbdesign)
    • Re: registering users of an access database
      ... MS Access MVP ... Access Security: www.ltcomputerdesigns.com/Security.htm ... "Alylia" wrote in message ... > I have almost completed an access database for my office which is going to ...
      (microsoft.public.access.security)
    • RE: access back end needs to be secure
      ... First read the Access Security FAQ at ... to secure your database. ... If you give users a login/password to access the system, ... know-how could log into the Access database directly. ...
      (microsoft.public.access.security)