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.
There seems to be a few small changes that they're making, and I think this is a good thing. While this stuff isn't ground breaking, it is important, and I think Windows has missed this polish for the past 10 odd years. Personally I wouldn't care for moving it anywhere else other than where it is but I am very grateful that they did change it from that stupid Windows 8 one!
Hey, maybe attended robotaxis can start a trend, where all automated robo stuff gets chaperoned by a human!
Automated self-checkouts in grocery stores could be manned by humans who will scan the items for you and bag them, for safety reasons of course. It's not healthy for my frustration level at all when I buy a bag and it insists that I take it off since I've now messed up the scale.
And a human attendant for robo-answerers, you know, to prevent customers from stroking out in automated attendant hell.
"AGENT. REAL PERSON. GIVE ME A REAL PERSON. REAL ######ING PERSON. SOMEONE OTHER THAN A STUPID ROBOT VOICE ON A STUPID LOOP THAT CAN'T HELP ME. HAAAALLLLLPPPP!"
Personally I prefer the Control Panel, a real desktop application with tabs in contrast to Settings, an app designed for mobile with everything giant resized, thought and designed for full screen, very limited and does not support more than one window in a windowed operating system.
Question
Greenstein
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