You do not have permissing to make changes

[Annelie]

I am the owner of everything in this database, including the database. I
have giving myself administrative rights to every table, query, etc. Yet I
have one query, which I own and have administrative rights to, which, when I
want to make changes to, it gives me the error message that I have not
rights to make changes.
What could be happening here?
Annelie

 

[TC]

If you own the query, you should definitely be able to change it.

So my bet is, you do not own the query!

Perhaps silly questions, but:
- how do you know that you own the query?
- how do you know that you have Administer permission to the query?
- is it a Run With Owner Permissions (RWOP) query?

HTH,
TC

 

[TC]

----- Annelie wrote: -----

I am the owner of everything in this database, including the database. I
have giving myself administrative rights to every table, query, etc. Yet I
have one query, which I own and have administrative rights to, which, when I
want to make changes to, it gives me the error message that I have not
rights to make changes.
What could be happening here?
Annelie

hi i am having the same problem if anyone could help please e-mail
janice

No. "Ask here, answer here". This is so everyone can benefit from the
answers provided.

TC

 

[Guest]

----- Annelie wrote: -----

I am the owner of everything in this database, including the database. I
have giving myself administrative rights to every table, query, etc. Yet I
have one query, which I own and have administrative rights to, which, when I
want to make changes to, it gives me the error message that I have not
rights to make changes.
What could be happening here?
Annelie

hi i am having the same problem if anyone could help please e-mail
janice

 

[Annelie]

It shows that the current user is Admin. The report is owned by Admin.
Shouldn't admin have the right to everything?

 

[TC]

Huh?

Let's try again.

- how do you know that you own the query?

- how do you know that you have Administer permission to the query?

- is it a Run With Owner Permissions (RWOP) query?

TC