OWE!!!  I finally found out what was wrong



LEARN FROM MY POOR PROGRAMMING CONVENTIONS



I am a pretty decent programmer, however, I'm learning web application 

programming the hard way.  I found out that I should stick to good naming 

practices for the fields of my database.  ODBC rules must be followed.  I 

had a checkbox (yes/no) field that I had named "home?" as in "Is this a 

home game?".  Bad idea, stay away from non-standard characters because 

they too may be reserved  8(



I am posting the answer for others who may follow my fate!





> Gad I thought I was about to get back to coding my content.  The only 

line 

> of code I'm changing is the connection string from a DSNless to DSN 

> connection.

> 

> DSNless (everything works fine)

> 

> con.Open("Provider=Microsoft.Jet.OLEDB.3.51;Data 

Source=C:\path\p2001.mdb")

> 

> DSN

> 

> con.Open "DSN=2001db"

> 

> I get the following 

> 

> Microsoft OLE DB Provider for ODBC Drivers error '80040e10' 

> 

> [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect 

> 

> pointing at this string

> 

> Set rsGameMatches = con.Execute( " my SQL string ...