[AccessD] RE: Linking to replicated Access 97 BE with Access 2000 FE

UPDATE:

If I show hidden and system objects, I get all the fields. It appears
that Access 2000 is hiding the wrong fields.

So anyone seen this?

Scott Marcus
TSS Technologies, Inc.
marcus at tsstech.com

-----Original Message-----
From: Scott Marcus 
Sent: Tuesday, February 01, 2005 7:25 AM
To: 'Access Developers discussion and problem solving'
Subject: Linking to replicated Access 97 BE with Access 2000 FE

I'm trying to link to an Access 97 back end replicated database in
Access 2000. When I do this, the tables in the linkage look fine but
when you open them, all the fields are not there. For instance, I have a
table with 3 fields in it (actually 6 when you count the ones added for
replication) that when viewed in Access 2000/2003 only the 3 replication
fields show.

I have tried compacting/repairing the Access 97 mdb this still does not
fix the problem. I cannot convert the mdb to Access 2000/2003 because
I'm running this database in a mixed environment that has several very
old laptops that barely run Access 97.

Anyone else seen this problem and know a software solution?

I may just install Access 97 on the server for the easy way out.

Scott Marcus
TSS Technologies, Inc.
marcus at tsstech.com