Hi Steve,
I have recently done something like this.
I discovered that while you can have 2 recordsets based on the same table
open at the same time, that you cannot edit/update either of them.
I was working with a multitude of tables that I was attempting to modify and
merge, and came up with the idea of creating a copy of the table to "read"
from, and then "writing" to the original.
'We cannot modify the table that we are importing because we
'have an open recordset, so I make a duplicate copy that I can
'mess around with.
DoCmd.CopyObject , strTableName & "1", acTable, strTableName
If you want all of the code I was using, please reply either here of via
e-mail.
Don
"Steve Leferve" <le********@osu.edu> wrote in message
news:c8**********@charm.magnus.acs.ohio-state.edu...
Hey folks
I'm working on a 'duplicate' function. I need to duplicate related child
records in the same subtable.
Two questions:
1. My 'db.execute' function is not working. How can I trouble shoot it?
The SQL insert syntax looks okay. However, the records don't go in. There is
no error message.
2. Can I open the same table in two different recordset objects? I need to
loop through a series of records, and then insert the values of each one
again, into the same table, but with different parent ids.
Steve Lefevre