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

What is PHP? (Views: 2697)

MySQL Alter Table - How to rename table names and column names in mysql ? (Views: 2341)

What is phpMyAdmin? (Views: 2257)

I cannot login / access phpMyAdmin (Views: 2414)

How do I use a Microsoft Access database on Windows Plesk Hosting. (Views: 9275)