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

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

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

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

What is MySQL? (Views: 2729)

How can I RESTORE a MySQL database from the command line? (Views: 2272)