Update (and Add) always gives an error message

[Rich Paino]

This short bit of code:

<%
Set MyDb = Server.CreateObject(&#34;ASPDB.EP&#34
MyDb.dbmdb=Server.MapPath(&#34;PMQA.mdb&#34
MyDb.dbUnit=333444
MyDb.dbSQL = &#34;SELECT * FROM [Customer Info] &#34;
MyDb.dbMode=&#34;Grid&#34;
MyDb.dbNavigationItem = &#34;Top,Prev,Next,Bottom,Reload,Update,Add&#34 ;
MyDb.dbEditParams=&#34;TableName=[Customer Info], BookMarkFlds=Order#, TableTag=BORDER=2&#34;
MyDb.aspDBEP

%>

ALWAYS gives this error:

Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503

[Mark]

Rich,

This is almost always caused by a reserved word in a field name, such as
[Hire Date] Date is illegal!

Mark.


------------
Rich Paino at 5/24/01 5:09:19 PM

This short bit of code:

<%
Set MyDb = Server.CreateObject(&#34;ASPDB.EP&#34
MyDb.dbmdb=Server.MapPath(&#34;PMQA.mdb&#34
MyDb.dbUnit=333444
MyDb.dbSQL = &#34;SELECT * FROM [Customer Info] &#34;
MyDb.dbMode=&#34;Grid&#34;
MyDb.dbNavigationItem = &#34;Top,Prev,Next,Bottom,Reload,Update,Add&#34 ;
MyDb.dbEditParams=&#34;TableName=[Customer Info], BookMarkFlds=Order#, TableTag=BORDER=2&#34;
MyDb.aspDBEP

%>

ALWAYS gives this error:

Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3503