Results 1 to 4 of 4

Any recommendations on how to password protect a DB on a network?

  1. #1
    darklich is offline Novice
    Windows 10 Access 2003
    Join Date
    Oct 2018
    Posts
    2

    Any recommendations on how to password protect a DB on a network?

    Basically I am concerned that if someone remotes into my network with the correct privileges that they can then ransomware or straight up steal valuable company data. Does anyone have experience with any third party programs that can slap a password on my.MDB? We had a scare recently where someone was able to get local admin access, but thankfully were not able to access the network where the DB is stored. I'm just trying to be proactive here. Thank you.

  2. #2
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,389
    Why can't you use the built in 'security' to password protect / encrypt the MDB file directly from Access?
    MDB files are not very secure but its better than nothing.
    However if you are worried about security, you should be using ACCDB/ACCDE files instead or putting the backend data in SQL Server.

    For more information, see these articles:
    http://www.mendipdatasystems.co.uk/c...ity/4594431226
    https://www.everythingaccess.com/tut...under-the-hood
    Colin (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    darklich is offline Novice
    Windows 10 Access 2003
    Join Date
    Oct 2018
    Posts
    2
    Thank you for the reply. I guess this may not be the best place to ask this. It is more of a networking issue i suppose. I was hoping that there was a 3rd party program that would do a kind of two step authentication before accessing the DB.

    As for SQL Server, me and others have been begging them to do this for years. Thank you.

  4. #4
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,389
    I am concerned that if someone remotes into my network with the correct privileges that they can then ransomware or straight up steal valuable company data.
    Reading this again, I may have misunderstood what you meant.
    I'd still start by making it as secure as possible onsite - split db with ACCDE front end with user login, no nav pane, no ribbon & various locked down options + ACCDB (or SQL) backend with password encryption.

    You can't prevent users with access to the FE from copying the FE file BUT don't give users permissions to open the BE folder & they can't copy the BE
    You can stop the FE being run offsite by tying the app to a particular machine
    To do so, you check items like the hard drive number, CPU ID & motherboard ID - basically its an activation process.
    If the values don't tally, users won't be able to run the app

    I've done this successfully on a couple of my commercial apps but doing all the above is a lot of work to setup and thoroughly test.

    Good luck
    Colin (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Password protect a design
    By Skydiver16 in forum Database Design
    Replies: 2
    Last Post: 08-06-2016, 03:08 AM
  2. Password Protect Field
    By KMan in forum Access
    Replies: 1
    Last Post: 06-20-2016, 06:56 AM
  3. Replies: 4
    Last Post: 11-28-2014, 12:43 AM
  4. password protect form
    By nkuebelbeck in forum Forms
    Replies: 2
    Last Post: 01-15-2012, 12:02 PM
  5. Password Protect Forms
    By Robert M in forum Programming
    Replies: 3
    Last Post: 01-15-2010, 12:50 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums