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