Hi I've added a begintrans command to my code in the following way:

conn.begintrans

rs1.open
rs1.addnew
'added all my data
rs1.update

rs2.open
rs2.addnew
'added all my data
rs2.update

conn.committrans

I've then gone and delete these transactions using code like this

conn.execute "delete from table1"

when I then re-do the transaction I get the following error on the begintrans command.

when using a sequal database:

"Transaction can not start because more than one odbc connection in use

when using an access database:

"Can not set attribute at this time"

can you please tell me what I am doing wrong