sql - Syntax Error MS-Access query in VB (but not in Ms Access) -
i trying create table programmatically through visual basic (visual basic studio 2008 .net framework 3.5) ms-access database.
i using following syntax:
create table datosftp ( id autoincrement, direccion text, usuario varchar(30), password varchar(30), passwordbd text, primary key(id) )
but launchs me following exception: "syntax error in field definition"
however, if execute query in ms access (the program), works perfectly.
does know can be?
thanks in advance.
password reserved word.
try this
create table datosftp ( id autoincrement, direccion text, usuario varchar(30), [password] varchar(30), passwordbd text, primary key(id) )
Comments
Post a Comment