Access 2000 security issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
Back
Top