Please could you help me. I added a new user and deleted two users on Friday using the security wizard then modified a DB. When I tried to open one of my DB this morning I was not prompted to enter user name and password as normal just DB password then an error message came up that 'I did not have the necessary permissions to use the DB and have the administrator or person who created this object set the necessary permissions for you'. I am the administrator for all my DBs (I have 5 in total). The DB are stored on a network and IT restored my DBs from previous night and this still has not worked is there any way of fixing this I have ten years worth of data in some of these DBs.
try to restore the workgroup file .mdw, that contains all the permissions
you shouldn't need to restore the data, just the permissions, you may need to re-associate the permisssions files with the individual users
Ive always tended to change the password of old users just in case they have created an object which I need access to at a later date.