I have an Access 2002 database running on Access 2007. After compacting the database it looked like it lost 1/3 of the tables. After I selected show hidden objects, the missing tables turned up as hidden items with the owner set to "<unknown>". The queries,forms and reports all look OK, with owner set to "admin" (no permissions set). With User and Group permissions I am unable to set the owner to admin, and unable to read the tables.

The original database was set up with replication (which is a little 2007 unfriendly)

I would appreciate some help as to what I can do to recover the unreadable tables, thanks PJ

Can you view all of the data when viewing the table through a query?

If so, perhaps you could duplicate the table with a make table query.

__________________
Shane

If your issue is resolved...mark it so - here's how!

Thanks for the reply, unfortunately I can't add the hidden tables to a query, or when I use the query wizard, the fields are not available. The table names are visible, when I select to show hidden tables.

PJ

I take it you had not applied Office 2007 SP2 yet?
http://allenbrowne.com/Access2007.html#Bugs

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Definitely running 2007 SP2. Also with further searching I found an earlier file with the owner listed as "Engine" for my missing tables. Table properties set to hidden and no permissions set for anyone but the owner "Engine".

I'm not sure where that leaves this thread. Were you able to piece together your tables from the previous copies?

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

I have an old backup copy with alot of missing recent data, unfortunately the regular back up process has backed up the corrupted data and it wasn't picked up for some time. Very Frustrating. Planning to rebuild database in 2007 version. I hope this reduces the risk. PJ

create another database and see if you can import the tables to a new database?

If you are savy with VBA you can get tables and do with them what you want. VBA should be able to bypass any restrictions that Access places on tables. YOu can use commands to copy the tables to new names. If you want to know how please write me at carlmdobbs@gmail.com. I don't want to give you the solution now because it would take a lot of time to create the code for you and you may not want it. I can definitely give you the code if you just indicate you want it. If you simply reply to this posting I'll get the message by this forum and respond but writing me directly may be your better choice.

In any case, I am an expert at VBA and have 13 years experience as a programmer. I can't imagine your hidden tables problems with permissions has any resistence to MS Access VBA code. It is code that makes Access do what it does. Go with VBA and you can make Access do anything because you control it directly.

Don't worry. If the tables aren't corrupted you can copy them and extract data directly.

Thanks for the response. I am keen to try VBA. I do have elimentry VBA skills and I think it is worth trying. I have separately emailed my contact info to your gmail address, and would appreciate your reply

After help from carlmdobbs, we could not read the effected tables with VB code. will separately post to read table with different owner

Resolved at last !

Downloaded "Recovery Toolbox for Access" and ran on effected database. This successfully extracted tables and data into a new database file. Reconstructed as an Access 2007 database and all OK .

Thanks for the update.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"