How to open in deny-read

[S.L.]

I use ADO to access MS Jet table. I uses cnn.begintrans and cnn.committrans
for transaction. In transaction, cnn is used for open and update many
recordsets from different tables. I want to open some tables in transaction
in deny-read mode. I don't want others to read it.

In Help file it written that .mode property can do this but .mode is apply
to cnn. if that is true, all open tables (which derived from cnn) will also
be opened in deny-read mode. Have any solution ?

TIA

 

[david epsom dot com dot au]

to cnn. if that is true, all open tables (which derived from cnn) will
also

be opened in deny-read mode. Have any solution ?

Open another connection.

(david)