对access添加纪录的错误.

[dig]

执行语句:insert into index (id,name,title,level,main,boss,email,passwd) value ('aaa',' ','ccc',3,'bbb','sggggggg',' ','111') 的时候出现错误:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC Microsoft Access 驱动程序] INSERT INTO 语句的语法错误。



实在想不出来是为什么,请指点.不胜感激

[dreamghost]

insert into index (id,name,title,level,main,boss,email,passwd) value ('aaa',' ','ccc',3,'bbb','sggggggg',' ','111')

老大···应该是values吧··你少了一个S·····

[11830]

这样试试
insert into index (id,name,title,level,main,boss,email,passwd) values ('aaa',' ','ccc',3,'bbb','sggggggg',' ','111')