Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
(March 26, 2001) 
Question:
I have noticed several people have been receiving this error as well as myself. I'm using an Access 2000 DB & I've tried it on SQL 7.0.
I receive this error on BOTH types of DBs:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
Any resolution to this so far?
Answer:
Identity works with Access 2000 ONLY if you use the "Jet OLEDB Provider 4.0"!
So define your ODBC connection not with "Microsoft Access Driver" but with "Jet OLEDB Provider 4.0". So your connection string should look like:
"Provider=Microsoft.Jet.OLEDB.4.0;Data source="C":\Backup\OBS\Development\Db\obs2k.mdb;Persist Security info="False""
If you use a DSN-Less connection. Otherwise its in the ODBC Settings.
Read more about this in the following ASPWATCH article
George Petrov
George Petrov is the Founder of the highly successful Zones: DMXzone.com, FWzone.net, FLzone.com, CFzone.net, DNzone.com and FlashFiles.nl
He has developed the comprehensive Dynamic Zones Content Management System that is the brains driving them and constantly supports their online communities with his extensive and valuable knowledge.
He is a renowned web development 'Guru' who has written many articles and extension for Adobe's Dreamweaver.
George Petrov is also the CEO and Founder of Dynamic Zones and also very proud of his children Sofie, Victor and Alexander!
User Reviews
Total of 15 reviewsNever did get this working.
Written by G Ether on November 15, 2004Dreamweaver MX, I did also get the js error but got the path fixed but no matter what I did I got error messages and IIS 5 error loading the page. I use a redirect page that gives me the session NewID then go to the form page and have a hidden ...
Reserved words
Written by Johan Arvidsson on March 1, 2004The error message can also be shown if the name of one or more fields in the database is a MS Jet reserved word or includes a reserved sign like '-', ie 'ID-person'. A list of reserved words can be found on microsofts webpage, ...
RE: RE: RE: RE: Microsoft JET Database Engine error '80040e14'
Written by Simone Berretti on December 4, 2003Thank you very much for the help
RE: RE: RE: Microsoft JET Database Engine error '80040e14'
Written by ben dykes on December 4, 2003Yes, DWMX had written the SQL statement incorrectly there were two ' ' missing from the code: insertCustID.CommandText = 'INSERT INTO tblCustID (cust) VALUES (' + Replace(insertCustID__varCust, ''', '''') + ')' Should be: insertCustID.CommandText = ...
RE: RE: Microsoft JET Database Engine error '80040e14'
Written by Simone Berretti on December 3, 2003No, i don't find any solution... and you?
RE: Microsoft JET Database Engine error '80040e14'
Written by ben dykes on December 2, 2003Hi Simone, Did you ever get a solution to the JET DB error you posted? I'm getting a similar error: Error Type:Microsoft JET Database Engine (0x80040E14)Syntax error in INSERT INTO ...
Microsoft JET Database Engine error '80040e14'
Written by Simone Berretti on October 2, 2003Hi, I work with ACCESS 2000 (as I see in the other FAQ) and I use Microsoft.Jet.OLEDB.4.0 (my connection string is: 'Provider=Microsoft.Jet.OLEDB.4.0; Data source='C':\Documents and ...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
Written by Kenny Darcy on April 3, 2003Hi Yea,I am at my withs end. I keep getting Microsoft OLE DB Provider for ODBC Driverserror '80040e14' , I have reloaded PWS, Windows, Access and dreamweaver a few times to get everything on my machine working again but no joy, I cant seem to see ...
