runtime error -2147217900(80040e14)

[Bvreddy]

hi everyone,

can we use insert statement in MS-Access database
i am getting runtime error syntax error in Insert into statement.

sql = " Insert tablename values(' ',' ',0,' ')"
conn.execute sql

is this correct.
iam getting this
runtime error -2147217900(80040e14) syntax error in Insert into statement.

error message.

can any assit me regarding this.

 

[chiph]

Did you miss/skip any columns?

Do the datatypes of the values you supply match the datatypes of the columns in the database?

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[mansii]

As far as I know, the string looks like this:

sql = "insert into TBLNAME (FieldList) values (ValueList)"

 

[Bvreddy]

even i am getting the same error message when deleting the records by passing the recordid

delete tablename where id = " & ID

runtime error -2147217900(80040e14) syntax error (missing operator) in query expression.

i checked the query every thing is fine but i still get this error while adding or deleting any record into the table. i am using vb6 and Ms-access database.

plz can any one assit me as soon as posible.

 

[mansii]

Perhaps,

delete tablename where id = " & ID

should be like this:

"delete from tablename where id = " & ID

Or maybe you could show us more of your codes?

Regards

 

[vbSun]

Reddy,

You have the root of your problems in the SQLs that you are using, as Mansii had already pointed out.

------------------------------------------
The faulty interface lies between the chair and the keyboard.

 

[Bvreddy]

hi Sun,

thanks but any how i managed to sort it out. As this came because i initially using SQL server backend but not i am forced to use MS-Access. So when converting the i got this. Now it is fine.