syntax error in simple INSERT

What is wrong with this statement? I'm getting a SYNTAX ERROR IN INSERT INTO STATEMENT error on it. But of course when I put it into Access, it works just fine :mad:


cn.Execute "INSERT INTO Tags ([Tag]) VALUES (" & 5 & ")"


The field Tag is a number field that is the primary key.

"INSERT INTO Tags ([Tag]) VALUES (5)"


Shurik.

"INSERT INTO Tags ([Tag]) VALUES (5)"


Shurik.

doesn't like that either....it makes no sense huh

if you field is not autonumber it should work

if you field is not autonumber it should work

It's not autonumber. Anyway, I recreated the table and named it something else and it works now. Whatever sense that makes, I don't know...I'll chalk it up to Microsoft.

Thanks tho.

Maybe your database needed to be compacted and repaired. Access databases need to be repaired frequently because it is a flat file and all processing involves reading the whole file into memory.

Why not try the below code:

Dim SQL as String
SQL="INSERT INTO Tags ([Tag]) VALUES (5)"
Docmd.RunSQL(SQL)

I assume that you are writing code in MS-Access VBA.