DAO Library Problems

[Virgil]

Folks, I noticed something strange between two reference
library versions, DAO 3.51 and DAO 3.6. IF I reference DAO
3.6, my database can't find the MySysRepInfo table
(replication info). I developed code in using DAO 3.51 to
use that table to discern whether a database is either the
Design Master or a Replica (DesignMasterID and
ReplicaID). Is that normal for DAO 3.6?

If this is normal, then how can you program using DAO 3.6
to tell the difference between the Design Master and the
Replica?

Additional info: I noticed the difference running Access
97.

 

[Allen Browne]

DAO 3.6 is designed for JET 4 (Access 2000 and later).
It will not work correctly with Access 97 (JET 3.5).

 

[Virgil]

Understood. But 3.6 doesn't recognize the MySysRepInfo
table in Access 2000 and beyond either. So, the question
back the the users group is how can you program using DAO
3.6 to get the database to distingush between the Design
Master and the Replica?

 

[Allen Browne]

The replication is different in JET 4, but it is not something I use.

michka has several articles relating to replication at:
http://www.trigeminal.com/usenet/usenet.asp?1033
including the differences between JET 3.5 and JET 4, and also a couple of
utilities relating to replication at:
http://www.trigeminal.com/utility.asp?1033

If that does not help, and no one else replies, try posting to:
microsoft.public.access.replication

 

[Paul Overway]

DAO 3.6 will work fine with Access 97 databases, but 3.51 does not work with
Access 2000+.

As for determining whether a database is the Design Master or a replica, see

http://support.microsoft.com/Default.aspx?kbid=210224

Note that this function also indicates whether the database is a replica.
The same function works in Access 97.