Update/add record in table error

[Chad C]

I am trying to update/add a record in table. I have found I can delete them easily.

My Add Error:

Error#=800040e14(-2147217900)
Desc=[MS][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = -3502

My ASP code:

<%
Set MyDb = Server.CreateObject(&#34;ASPDB.ep&#34
Mydb.dbMDB = Server.MapPath(&#34;dbhockey.mdb&#34
MyDb.dbSQL = &#34;Select * FROM Schedule&#34;
MyDb.dbGridTableTag = &#34;BORDER= 1 CELLPADDING=3 CELLSPACING=3&#34;
MyDb.dbcolor=&#34;5,,lightcyan,,false&#34;
MyDb.dbNavigation = &#34;BOTH&#34;
Mydb.dbNavigationItem = &#34;Reload, Update, Delete, Add&#34;
MyDb.dbeditparams = &#34;Tablename=schedule, bookmarkflds=ID&#34;
MyDb.dbGridDisplayFlds=&#34;1,2,3&#34;
Mydb.dbgridinc = 100
MyDb.dbMode=&#34;dual-horiz&#34;
MyDb.aspDBep
%>


I have a players table that works just fine. I was wondering if things such as Autonumbering, Yes/No values in the table design can cause problems when working with this.

Thanks
Chad