The only solution I know of is to create a brand new database and import
each of the objects into it.
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.