I have created a database and want to restrict the priveliges of certain users so records cannot be deleted, designs changed, etc. Under the user and group permissions, I discovered that even though I'm logged onto the machine under my username, the 'Current user' is 'Admin'. I have no idea where this name came from, and therefore how to log in as someone else. When I log onto the machine as a different user and try to run the database, it tells me the database is read only, and it's unable to run a macro I've used to go to a new record. However there is only ever one user listed in the database. When running the database as myself (i.e. 'Admin' as it calls me), I tried creating new users under my own username and that of another user, and assigning full rights to the other user, but even when logged in as that other user, Access still reported the same error, presumably to do with user permissions. I'm presuming that once I've got the database to recognise different users, the permission setting will follow without too much trouble, but this was really the first hurdle as it stood.
The next twist was, I tried making a different user the owner of the database and its contents, and when I logged in as that user, I still didn't have any more permission, but nor did I have the right to remove or modify any of the accounts previously created by 'Admin'. When I logged back in as myself (i.e. 'Admin' or so it thinks), this modify permissions / create users access failed to return, even after I restored database and object ownership to 'Admin'. So as far as I can tell, the situation is currently as it was to start with (database ownership, permissions), but I no longer have the rights to change any permissions, and therefore implement any suggestions which this forum may present.
So my question is: how do I restore the right to modify permissions; how does Access use usernames and how are these linked to the Windows XP username.
Any assistance greatly appreciated.
The next twist was, I tried making a different user the owner of the database and its contents, and when I logged in as that user, I still didn't have any more permission, but nor did I have the right to remove or modify any of the accounts previously created by 'Admin'. When I logged back in as myself (i.e. 'Admin' or so it thinks), this modify permissions / create users access failed to return, even after I restored database and object ownership to 'Admin'. So as far as I can tell, the situation is currently as it was to start with (database ownership, permissions), but I no longer have the rights to change any permissions, and therefore implement any suggestions which this forum may present.
So my question is: how do I restore the right to modify permissions; how does Access use usernames and how are these linked to the Windows XP username.
Any assistance greatly appreciated.