error 3008 using INSERT INTO by VBA

[Giobbe02]

hello,

I have a problem with INSERT INTO....my form is connected to a Table "Cod" which has 2 fields: 'Cod' and 'Option', through my form I want to insert as many records as many options I have:
Example: cod: 4333333349 option: banana option:apple

Cod	Option
4333333349	banana
4333333349	apple

<tbody>
</tbody>

when I try to do it ACCESS says to me Error '3008': the table is already open with exclusive access from an other user....

my code:

Private Sub insert_rec_Cod()


CurrentDb.Execute "INSERT INTO Cod" _
& "([Cod], [OPT]) VALUES " _
& "(" & 4444444 & ", " & 4 & ");"


End Sub





Anyone knows a way to solve it?

thanks
cheers

 

[SydneyGeek]

If the form is bound to that table, don't try to run an INSERT statement at the same time; the form has locked the table.
Why aren't you just using the form for data entry? When you enter the values and go to a new record, it should just be saved to the table. Alternatively, you can have your data in another table (tblTemp), close the form and use something like this:

INSERT INTO Cod ([Cod],[Option])
SELECT Cod, Option FROM tblTemp

Denis