Need help with this one please
I have three modules in DB, each is a database but being treated as a table. The first module is the general work area and requires a password. It is called "Incidents". The second module is called "Housekeeping" and the third is called "guards". The first logon is a general user logon and password. This works. I need to be able to force a Different logon and password ie., a (supervisor) logon and password for the 2nd and 3rd module. I have tried all sorts of things in scripts etc but cant seem to get it to work. Perhaps it cant be done. I am using version 8 pro advanced.
Any help with this would be much appreciated.