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) ) 

reserved words


Comments

Popular posts from this blog

c# - How to get the current UAC mode -

postgresql - Lazarus + Postgres: incomplete startup packet -

javascript - Ajax jqXHR.status==0 fix error -