Security & Modified Form

[StacyStacy]

Please help ... what did I not do correctly?

When modifying a form in the administrator mode - I can modify the design of the db without problems (I modified an 'Add' button on a form) and it works! I've copied the .fe, .be and .bak to the live directory. But when a user logs in and accesses the form, the modification that I made as the 'Adminstrator' for the 'Add' button on that form did not update. What do I need to do or where did I go wrong.

Please advise ...
Thanks

 

[StacyStacy]

Thanks Pat ... but I've done everything you have stated in your response ... and no one is in the live database while I am modifying it. I actually work in a "testing area" elsewhere on the server.

 

[StacyStacy]

Thanks, but I am only using one version and I am aware of the correct file for this project. Additionally, I just spoken with an Instructor who is well versed in Access. He stated that there are known instances of gliches such as this. He advised me to elimate the existing security files and redo them ... ;\

Thanks for you help. I appreciate all of your help.

 

[StacyStacy]

I don't see how my copy failed, being that no one was in the db when it was opened and the correct version is available to the user, even me, when I log on as both the user or Admin ... in both the live database and in the testing area. Your thoughts? Is there something that I am missing ...?

 

[StacyStacy]

This is new ... I noticed after playing around with the Administrator's security/permissions, that after assigning the UpdateUsers under the Administrators ... (I may not be articulating this correctly...bare with me) I could now log on as the User and the button on the form worked that was previously modified under the Administrator ...

Does this make sense to you?

 

[StacyStacy]

- I do not totally understand the "Jet" in Access/"Jet" security.
- Yes, I saw a way to add security to an individual control when I created the security.
- Which tree do I need to bark at?
- No, the form does not work correctly on my PC when I opened it as the user, "InfoProc". The issue with the modified button is a big problem.
- Yes, the form works correctly on the user's PC when I opened it as the "Administrator". I could correctly use the modified button.
- Yes, the form works correctly for the other user, "DJones". There are 2 users: InfoProc (this user can access the form only in the db) and DJones (she can access either the form or a spreadsheet view).
- There is not different data in the two copies so that the button appears to work in one situation but not in the other. The db has been split.
- I changed something visible on the form and distributed it to the user. Both users saw the change. So, why can I not program a button where "InfoProc" will log in and be able to use the modified button?
- As far as the button, no, it still does not work for the user, "InfoProc", but again, "InfoProc: can see the color change on the form itself.
Why is this occuring????

 

[StacyStacy]

Security Issue Resolved

The resolution to this problem was to enable the user, "InfoProc" to read, write, update, etc., to the table from which the form uses.

This was too simple. Autoeng suggested that I download the Security Add-in Manager. He says it's really simple to use instead of the Access security setup.

Here's the links:
http://www.access-programmers.co.uk/forums/showthread.php?t=39331&highlight=security+add-in

http://www.access-programmers.co.uk/forums/showthread.php?t=48236&highlight=security+add-in

http://www.access-programmers.co.uk/forums/showthread.php?t=52524&highlight=security+add-in

Thanks!