By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

transactions and linked tables (advise requested)

P: n/a
I am looking for some advise.

I would like to do the following

dim rst as ADODB.recordset
set rst = currentdb.openrecordset("mytable",dbOpenDynaset)
with rst
BeginTrans
.AddNew
![Field1]="new value"
[.....]
.Update
CommitTrans
end with

"mytable" is a linked table (Access2000 front end, and MS SQL backend,
via ODBC)

The question is:

Will BeginTrans / CommitTrans have any effect on the linked table? If
not, what would be a better way to it? Or, does AddNew and Update
effectively do the same?

Thanks, and sorry if this is too basic - I am relatively new to
transaction methods.
Wei Liang
Feb 2 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.