Security doesn't work after installing application on the server

[Anna Anna]

Hi!
I recently designed a database application but security offered by Access seemed to me a bit to complicated so I tried to be “smarter”. I start to regret it slowly. In properties of a main form I locked and disenabled most of fields and command buttons. I also created three buttons opening password forms. Each password form gives different level of access to the database.
After entering proper password and clicking ‘OK’ button, ‘click event’ unlocks some fields and enables some buttons on the main form.
After closing the main form or entire application, I have to go through the password forms again to get the same access.
Everything worked perfectly until database was installed on the server. Now, when you start the application all my locks don’t work. Everybody has access to everything all the time. ‘Network guy’ who put the application on the server said he didn’t make any changes to the database.
Does anybody have an idea what is going on?
Anna

 

[Autoeng]

Anna:

It sounds like you got the incorrect copy of your db loaded on the server. The code used to protect the fields / buttons couldn't be stripped out by the server. OR maybe your security is flawed. Please detail it.

Autoeng

 

[The_Doc_Man]

security offered by Access seemed to me a bit to complicated so I tried to be “smarter”. I start to regret it slowly.

Speed up the regret process so you can get over it.

The suggestions about code stripping made by Autoeng are unlikely. Code won't be stripped by moving a database from point A to point B. What might happen is that the security scheme depends on something that occurs on your system but isn't true for the server. His comments about flawed security design are far more likely.

Just because you have moved the database to another location does not mean that you have stopped being the administrator, does it? Look at all your settings to see if the defaults have changed for the locked fields or disabled fields.

 

[Autoeng]

You misread my post as I put that moving the db COULDN'T strip the code. Or maybe I wasn't too clear. Hell, after I read it again I'm kinda confused.

Autoeng

 

[Anna Anna]

Hi!
Thank you for your respond. Yes!!! I regret my short-cut
now but it doesn't help much. I have to fix it now anyway.
I will go there today to check all the settings (as you sugested)
and see. Will let you know.
Anna

 

[The_Doc_Man]

You're right, Auto. But then, I'm a graduate of a course in speed misreading. It is necessary in the world of government service, so that everything has to be excruciatingly - and incomprehensibly - precise.

Anyway, this sounds like one of two things has happened.

1. Someone has tapped the passwords

2. The app checks to see who is the user, but doesn't enforce use of a Workgroup. So of course, EVERYONE is in the Admins group when they first connect.

 

[Anna Anna]

Hi again!
I still don’t know why but all originally locked fields were unlocked and disabled buttons were enabled (only on main form). Fix was simple and quick though. Everything is working perfectly now.
Thanks again for your suggestions.
Anna