I have a FE, BE database on my home computer and a duplicate on the office
computer. Both use Ak2 on Windows XP. The one at home appears normal.
The BE consists of about 50 tables with numerous relation****ps and the FE
9
tables (fixed set up stuff) + the 50 linked table from the BE database. At
home on the relation****p view I see all the tables and their
relation****ps,
but on the office machine I see only the relation****ps between the FE
tables. Show all tables does nothing.
If I try adding the missing BE tables they appear in the Relation****p
window
without the "_1" suffix as if the table were shown twice, so they
apparently
aren't hidden somewhere. If I try to set up a relation****p, the various
options are greyed out as I would expect as you can't edit relation****ps
for
tables held in the BE DB in the front end.
Compact & Repair has dome no good (both Back End and Front End) Creating 2
new DBs and im****ting everything has equally failed. Has Access gone
corrupt?
Thanks
Phil
