I am creating a purchase request system for my company in Access 2000.
On the form, I have created an authentication area. Each request needs three authorisers before a purchase can be made. What I want to do is restrict who can authorise the requests by NT Logon id. I understand that Access has its own access levels as dictated within the JET database, but I would rather do this via Logon ID – then there is no question of a non authoriser, tampering with the security of the database (as canbe done if you know enough about JET) and authorising in the place of the given authoriser.
Is there a neat way in VBA to do this – does anyone have any sample code that could be used for such a purpose?
If I can understand how this works, then we have other databases that could be secured in this way. A colleague has a similar problem.