I created a MS access database.
I had then created a Workgroup Information File using Tools->Security->Workgroup Administrator.
I created a password for my used id('kanagab' which is same as my windows logon id) and was using the db.
The user id 'kanagab' was a member of 'Admins' Group and 'Users' group
There was another user called 'admin' which was ONLY a member of 'Users' group (This is what has mislead me .. ie., I had thought 'admin'user is a member of 'Admin' group too)
Later I wanted to remove the password for my user id 'kanagab'
But I had accidentally deleted the user 'kanagab'. Tools->Security->User Groups and Accounts->selected the usaer name 'kanagab'->Clicked 'Delete' button
So, now whenever I am opening my db, I am logged on as the user as 'admin' only and I do not have any run permissions.
I am not able to change the ownership of the db back to 'kanagab' because my current id ('admin') does not have administrator previlege.
I would really appreciate if someone help me on how to log on to my db with Admin previlege?
(More details in the document attached)
Thanks
Babu