DSNless Connection Causing Error....

I am forced to switch from a DSN connection to my database to a DSNless connection by my hosting company. I changed my connection string from this:

strConn = "dsnname"
set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open strConn

to the following:

set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:pathtodatabasemydb.mdb;"

I connect fine. But when I run a certain query, I get the following error:

Microsoft JET Database Engine error '80040e14'

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

The SQL statement in question here is:
SELECT MAX(week) AS LAST FROM Schedule WHERE Result <>''

If I change my connection back to the original DSN connection, everything is fine once again.

How would a different connection produce an error, and more importantly, how do I fix it?


Thanks,
Ted