Table Cannot be Manipulated Programmatically

[DougW via AccessMonster.com]

I want to be able to copy the last record in a table a number of times and
append those copied records to the table. I was able to create an Append
query that handles this. My normal data entry to this table is done via a
form bound to the table. I want to be able to run my append query from this
same form. I have created a field for the number of copies desired and an
action button on the form, to launch the append query. However when I
attempt to run the append query while the form is open, I get the error that
the table is already opened by another used or open through the user
interface and cannot be manipulated programmatically.

Is there any known work-around for this? I have tried binding my form to a
query of the table, rather than the table itself, but I get the same error.

I would really appreciate any tips on this - thanks!

-- Doug

 

[DougW via AccessMonster.com]

I figured it out - on the form, I just needed to set the form properties,
under Data/Record Locks, to "No Locks". Seems to be working fine now.