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 repair a damaged MySQL table, rebuild index or prepare for backup ? (Views: 2857)

I cannot login / access phpMyAdmin (Views: 2247)

How do I create a MySQL database in DNP ? (Views: 1908)

DSNless connection to MS Access (Views: 2145)

How to Backup your MySQL DB databases (Views: 2074)