Hello,

On my development machine, I wrote the code using DSN-less connection. On 
the host, it requires a DSN connection. I changed the connection strings 
from the DSN-less connection string to the DSN connection string, 
thinking that should be all that is required. Now I am getting 0x80040E14 
INSERT INTO syntax error and other similar error messages each time app 
goes to the db. Did I skip a step somewhere?

www.adopenstatic.com/faq/80040e14.asp will help with INSERT INTO errors.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Andrew Phillips" <cap269@c...>
Subject: [access_asp] Question about changing connection providers


: On my development machine, I wrote the code using DSN-less connection. On
: the host, it requires a DSN connection. I changed the connection strings
: from the DSN-less connection string to the DSN connection string,
: thinking that should be all that is required. Now I am getting 0x80040E14
: INSERT INTO syntax error and other similar error messages each time app
: goes to the db. Did I skip a step somewhere?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

That didn't help. My table contains no reserved words.

Please post the SQL statement you are using.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Andrew Phillips" <cap269@c...>
Subject: [access_asp] Re: Question about changing connection providers


: That didn't help. My table contains no reserved words.
: ---