Admin not granted permission?

Admin not granted permission?

Post by VEZlcnJ » Thu, 13 May 2004 04:46:03


My access database is telling me that I cannot run queries or look at tables that I wrote (and previously had access to).
I am in the database as Admin, and the Admin account has full read/write/delete/edit capability for all tables. However, all the queries are still marked as "Unknown" ownership. I cannot assign Admin ownership to these, no matter what I try
Is assigning ownership to all queries the answer
How do I do that when it won't let the Admin change them
I can change (and have changed) ownership for all tables, forms, reports, etc. Queries are the only items I cannot seem to get to work
What now
Tim
 
 
 

Admin not granted permission?

Post by Rick » Thu, 13 May 2004 06:08:04

The only solution I know of is to create a brand new database and import
each of the objects into it.

Rick B



My access database is telling me that I cannot run queries or look at tables
that I wrote (and previously had access to).
I am in the database as Admin, and the Admin account has full
read/write/delete/edit capability for all tables. However, all the queries
are still marked as "Unknown" ownership. I cannot assign Admin ownership to
these, no matter what I try.
Is assigning ownership to all queries the answer?
How do I do that when it won't let the Admin change them?
I can change (and have changed) ownership for all tables, forms, reports,
etc. Queries are the only items I cannot seem to get to work.
What now?
Tim

 
 
 

Admin not granted permission?

Post by bWVne » Thu, 13 May 2004 09:46:04

the only thing i can think of, is when you originally designed the tables etc, you didnt design them as Admin
You can only change the owner under the same user name you originally designed them under.
 
 
 

Admin not granted permission?

Post by TC » Thu, 13 May 2004 12:53:12

If object owners are marked "Unknown", this means those objects are owned by
a user who does not exist in the workgroup file you are currently using.
IOW, you are probably using the wrong workgroup file for that database. What
you are seeing is the expected result of using the wrong workgroup file for
a database.

HTH,
TC






tables
queries
to