Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ADOX and Replication

7 views
Skip to first unread message

Lothar Geyer

unread,
Jun 18, 2010, 2:08:27 PM6/18/10
to
David,

when I add a new table to a Jet database (design master) I must tell the
database that this table should be replicated. In DAO I used a (VB6-)command

table.Properties.Append table.CreateProperty("ReplicableBool",
dbBoolean, True)

I could not find information how to do this with ADOX. Is it the same way?

Thanks.
Lothar Geyer

David W. Fenton

unread,
Jun 18, 2010, 6:31:15 PM6/18/10
to
Lothar Geyer <Lothar...@EDV-Berater-Online.de> wrote in
news:881r0k...@mid.individual.net:

I don't know that it's doable via anything but DAO. JRO doesn't
support it, I think.

ADOX is the wrong interface for replicated Jet databases, in any
case.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Lothar Geyer

unread,
Jun 20, 2010, 11:18:41 AM6/20/10
to
Hi David,

Am 19.06.2010 00:31, schrieb David W. Fenton:
> ...


> ADOX is the wrong interface for replicated Jet databases, in any
> case.
>

what do you mean with "in any case"?

Lothar Geyer

David W. Fenton

unread,
Jun 20, 2010, 5:48:03 PM6/20/10
to
Lothar Geyer <Lothar...@EDV-Berater-Online.de> wrote in
news:886pq3...@mid.individual.net:

> Am 19.06.2010 00:31, schrieb David W. Fenton:
>> ...
>> ADOX is the wrong interface for replicated Jet databases, in any
>> case.
>>
> what do you mean with "in any case"?

It's a non-native interface, while DAO is native to Jet. DAO
provides for almost all the functionality Jet replication supports,
while ADOX is generalized for all databases and doesn't support many
Jet-specific functions (not just replication). That is, of course,
the reason why MS had to create JRO, to provide an interface to
Jet-specific functionality that was not provided in the generalized
libraries (ADO/ADOX).

0 new messages