Visible tables become hidden; how to access them?

[Guest]

This string began in the "Programming" section under the name "Help find lost
taables!".

One of my users suddenly couldn't open her application, and sent me her
app_be.mdb file. I discovered that about 1/2 of her tables were not listed
in the Database form. With help, I found that the table names can be seen by
checking the "System Objects" checkbox in the Tools|Options|View page
(checking "Hidden Objects" doesn't make them visible).

By viewing the Properties for the missing tables, I can see that "Hidden" is
grayed out, but checked.

Does anyone know how to (a) determine if the tables' contents are still
there, and (2) make the tables accessible to the user again?

Her last backup of the file is about 2 months ago....

 

[tina]

try opening one of the tables in a SELECT query, and let us know if you're
successful.

 

[Guest]

I have a table "tGifts" which has a query "qGifts". When I try to open
qGifts, I get the message "Record(s) cannot be read; no read permission on
tGifts. I get the same message when I try several other queries.

 

[TC]

If the query is a "un with owner permissions" (RWOP) query, then, the
user who owns the query does not have Read access to the table(s) in
question.

If it is NOT an RWOP query, then, the user who is /running/ the query
does not have Read access to the table(s) in question.

On way or the other, you have done something with the seurity sttings,
to cause one or more users to not have Read access to one or more
tables.

HTH,
TC

 

[tina]

if you have Access security implemented in this database, suggest you review
the security setup - see TC's comments elsewhere in this thread.

if Access security has NOT been implemented in the database, then my best
guess is that the tables in question, or the database as a whole, have
become corrupted. since the user's last backup is two months old (bad, bad),
you might try using a service that repairs/recovers corrupted dbs. see
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Recovery
for a couple links, or try googling.

hth

 

[Guest]

Taking your advice, I went to PK Solutions. It took them less than an hour
to discover that the "locked out" tables were owned by "Engine" (which one
normally can't log on as) and to extract them and rebuild the DB. Thanks for
your pointing me to the solution.

 

[tina]

hey, great - glad you were able to salvage the database.
i hope you give your user (all of them actually) a stern lecture about
backing up *frequently* - like daily, unless data is not
added/edited/deleted daily, in which case probably each day that data *is*
added/edited/deleted.

 

[Guest]

I built a cascading backup in sevreral months ago, but it also has a yes/no
option to allow for not backing up when no data has been added to the tables.
Prior to that I had a DOS program that did the same thing. Something aboaut
leading a horse to water, I think. Thanks again for your assistance!

 

[Guest]

This worked! This worked! Awesome Gordon!