INSERT INTO

I dont think you need the ; but i dont think that is the problem. The INSERT statament looks ok to me, but then I cant see the table your inserting into!

how does the code look before and after?

Du er nødt til skrive noget mere:

I Access 97:
Currentdb.Execute \"INSERT INTO Fangstrapport (Art) values (\'spejlkarpe\');\"

Eller i Access 2000:
Currentproject.Connection.execute \"INSERT INTO Fangstrapport (Art) values (\'spejlkarpe\');\"

/Thomas

Tak for hjælpen

/Mekaniker