asp.net gridview using Access database personal experience 090203

1,access database keyword has user, remember not to use in the table field name, this can cause syntax error, but not accurate hint keyword error.

The use of an UPDATE statement in a 2,access SQL statement differs from that of SQL Server.

Access:update companyres set type= ' where companyres.no= ' 2 '

SQL server:update companyres set type= ' where no= ' 2 '

SQL does not specify a table name, access needs to specify the table name.

The syntax error of the Microsoft JET Database Engine error ' 80040e14 ' INSERT into statement occurs when the field name and the reserved word are applied to differentiate.
Example:
Insert into Userlog (USERNAME,[PASSWORD],TRANSDATE,TRANSIP) Values (' &UserName& ', ' &Password& ', Now (), ' &TransIP& '

Keywords for 3,accsee database