• 0

MS Access Security Question


Question

I have created an Access database that resides on a shared server. On my own computer, I opened the database from the shared server and began to create users, groups, permissions, passwords, etc. I then went through and logged on as each user (still on my own computer) to ensure that the correct permissions were added, and they were.

I then went to each user, and had them open the database (on their own computer) just to make sure they were prompted to enter their username password, but they weren't. There were automatically logged on as Admin, just like any other unsecured d/b.

I tried to do some research, and it appears that the security I created is not specific to the database file itself, but rather to my hard drive. Now everytime I open any other database, I'm asked to enter the same credentials I created even though the other databases have no security whatsoever.

Does anyone know how I can fix this problem. I want each user to be able to open (from their own computer) the database from the shared server, but they need to be prompted a username and password.

Any help would be much appreciated.

Thanks.

Link to comment
https://www.neowin.net/forum/topic/130406-ms-access-security-question/
Share on other sites

3 answers to this question

Recommended Posts

  • 0

While most versions of Access work this way, knowing what version you're working with may help a little bit. The thing with passwords and permissions is that the file is separate and resides on your host computer. So, unless you want to go and do this set-up at every workstation you'll have to find another strategy.

The MS KB has reams of documentation on the short-comings of MC Access and this method of security.

Why do you need the l/p? Is it for data security?

  • 0
  maxanon said:
While most versions of Access work this way, knowing what version you're working with may help a little bit. The thing with passwords and permissions is that the file is separate and resides on your host computer. So, unless you want to go and do this set-up at every workstation you'll have to find another strategy.

The MS KB has reams of documentation on the short-comings of MC Access and this method of security.

Why do you need the l/p? Is it for data security?

Access 2000

I need the l/p for data security purposes.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • I think you need to adjust your style of approach. While some were affected by performance issues, and it's not a huge gap... you're acting as if Ryzen couldn't handle 11 at all. Performance issues are purely based on some facts in certain scenarios, while others are not. I see one link with a handful of people discussing the topic. I didn't join those topics or seek them out myself, as I didn't encounter noticeable drops in performance going from 10 to 11. It might also have to be because I don't have my nose stuck up the butt of single digit percentage points. I don't benchmark my PC every time something new comes out. Single percentage point differences in performance only ruffle the feathers of those that don't care about daily use. If you have a race car, do you compare that to your daily driver? Do you expect your Honda Accord to break the 9 second quarter mile like your 1000HP Pontiac Firebird? If you're so worried about FPS instead of enjoying your games... perhaps opening a curtain in your basement might provide a new perspective in life.
    • Currently updating my Win10 IoT Enterprise LTSC 2021 in a VM (QEMU/KVM) on Linux. but damn, updates take forever (makes me appreciate the lightness on Linux all the more). to give you a general idea... this update finished at 37 minutes into system uptime and I would estimate updates have been running roughly 20-30 minutes (some of this would be download time, but even subtracting that I would guess that 20-30min is close). granted, I only got two cores of my four core CPU (i5-3550) dedicated to the VM. but still, Linux wipes the floor with Windows in this regard.
    • It's disgusting that this exists and is being marketed by Neowin as a way to earn passive income. Support real writers and real arts. The world needs them more than ever. After at least 10 years, Neowin can GTFO my favorites bar.
    • It doesn't have to be "interesting" for a script/bot to just copy everything it finds and rehost it on another site. I hope you remember your post when AGI replaces not only your job and your career, but you entirely in the workforce...
  • Recent Achievements

    • Reacting Well
      rshit earned a badge
      Reacting Well
    • Reacting Well
      Alan- earned a badge
      Reacting Well
    • Week One Done
      IAMFLUXX earned a badge
      Week One Done
    • One Month Later
      Æhund earned a badge
      One Month Later
    • One Month Later
      CoolRaoul earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      531
    2. 2
      ATLien_0
      272
    3. 3
      +FloatingFatMan
      211
    4. 4
      +Edouard
      202
    5. 5
      snowy owl
      140
  • Tell a friend

    Love Neowin? Tell a friend!