Access 2000 security issue

[Guest]

I managed to create a secure database, I made myself one of the Admins. But
I decided to create a second logon for myself with the same Admins
permissions. I mistakenly created a query with the second logon (I'm still
designing). When I noticed my second logon owned the query, I tried to
change the ownership to my first logon. It won't let me do it. My second
logon can make and save changes to the query, but my first logon can not.
What is wrong

 

[Joan Wild]

Does the query owned by the second login have the Run permissions set to
owner? If so, set it to users. You should be able to change the owner to
the first logon, or grant the permissions to the first logon to make changes
(I would think the latter is the way to go)

 

[Guest]

Changing the qurey permissions to users worked
Thanks