VB Forum / Database Access / April 2006

Ok here's the problem, first time i saw that
i run a query in vb6 with the connection
cnconn.execute("the query")

the query is a insert. i made it directly on vb first after i tried it
in the access
database. It work perfectly in access but on vb side it says i got a
syntax
error in the insert into.
i tried with breakpoints and i did a ?querystring and it return me the
whole
query and just copy past in access and it work in access side.
idea what could be the prob.

here is the query (in french)
INSERT INTO tbl_billets_update ([# billet],[date],[heure debut2],
[heure fin2], code_operateur,nom,prenom,action,type,description) VALUES
(" & txtnumero.Text & ",#" & Year(Now()) & "-" & Month(Now()) & "-" &
Day(Now()) & "#,#" & Hour(Now()) & ":" & Minute(Now()) & "#,#" &
Hour(Now()) & ":" & Minute(Now()) & "#,'" & sender & "','" &
receiverlastname & "','" & receiverfirstname & "','26','03','Attitré a

in execute mode here the same with values in
INSERT INTO tbl_billets_update ([# billet],[date],[heure debut2],
[heure fin2], code_operateur,nom,prenom,action,type,description) VALUES
(2390,#2006-4-21#,#10:0#,#10:0#,'Gjoe','Joe','Gi','26','03','Attitré a

all fields are null allowed
i first tought that vb didnt like the fields with space, when i make db
i never use space or extended ascii char but i didnt made the database
and its too late to change there too much table linked and external
program running on it. Well all that to say ive removed all fields with
special char and space to keep only 1 field that is correct like the
"nom" field and still say syntax error in Insert Into