Knowledgebase

Microsoft JET Database Engine error '80040e14', Syntax error in...

If you get an error like this is it possible you are using a reserved word in your SQL - please see http://support.microsoft.com/default.aspx?scid=kb;EN-US;248738 for a list of resevereved words.

 

If you are using a reserved work you can usually get around the issue by enclose the field name in square brackets, eg...

 

SELECT [reservWordFieldName] FROM myTable;

Add to Favourites    Print this Article

How do I set the database permissions for a Microsoft Access file (*.mdb) on Windows Plesk. (Views: 3086)

error '80004005' Could not find installable ISAM (Views: 2953)

DSNless connection to MS Access (Views: 2314)

DSNLess connection to MS SQL (Views: 1917)

How do I create a MySQL database in Cpanel ? (Views: 2159)