permissions problem?

[Geoff Cox]

Hello,

I recently had my PC shut down suddenly whilst Access 2003 was open
and appeared to loose some queries. They reappeared when I selected
"show system objects".

But! I cannot open some of them - I get "could not read definitions;
no read definitions permissions for query ".

When I go to User and Group permissions and try to select Administer
permissions I get error message re "do not have Administer
permission".

I am the only person using this PC and could access the queries before
the sudden shutdown of the PC.

Ideas please?

Cheers

Geoff

 

[Phil Smith]

COPY THE DATABASE to another file, then try to do a compact/repair on
the copy.

 

[John Vinson]

I recently had my PC shut down suddenly whilst Access 2003 was open
and appeared to loose some queries. They reappeared when I selected
"show system objects".

Your systems tables are almost certainly corrupt. This database may be
salvagable... and it may not. Do you have a current backup? If not,
start a backup policy!!!

See http://www.granite.ab.ca/access/corruptmdbs.htm for some
suggestions on preventing and recovering from this kind of corruption.


John W. Vinson[MVP]

 

[Geoff Cox]

COPY THE DATABASE to another file, then try to do a compact/repair on
the copy.

Phil,

not sure hwta you mean - please spell it out for me!

Cheers

Geoff

 

[Geoff Cox]

Your systems tables are almost certainly corrupt. This database may be
salvagable... and it may not. Do you have a current backup? If not,
start a backup policy!!!

John,

I do have a backup made a couple of days ago but there have been a few
changes since then and it would be easier to correct the query problem
if I can.

I have found that I can import the queries from the backup - they have
1 added to their names to distinguish them from those already present
so not such a bad situation really!

See http://www.granite.ab.ca/access/corruptmdbs.htm for some
suggestions on preventing and recovering from this kind of corruption.

will have a look - thanks.

Cheers

Geoff

 

[John Vinson]

I have found that I can import the queries from the backup - they have
1 added to their names to distinguish them from those already present
so not such a bad situation really!

I'd really suggest importing everything possible into a new, blank
database. The bollixed queries may just be the most obvious symptom of
deeper problems!

Good news that you have a backup and were able to import from it!

John W. Vinson[MVP]

 

[Geoff Cox]

I'd really suggest importing everything possible into a new, blank
database. The bollixed queries may just be the most obvious symptom of
deeper problems!

OK - will do.

Thanks

Geoff