I have an access 2010 database which I only want certain people to have access to, but I dont want to password protect it for a whole host of reasons. I know that whatI am going to ask is not the most secure method but its the solution I need to implement ...
The database has a module to get the user's Network Login Name and is accessed with =GetOSUserName().
On opening the form "Welcome" I would like the database to lookup the Network Login Name in the table "Permissions", if it finds a match in the field [NetworkLoginName] then the form just opens normally. If it doesnt then it opens another form called "Access Denied" and closes the form "Welcome".
msgbox "Access denied"