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;
  • 1 brukere syntes dette svaret var til hjelp
Var dette svaret til hjelp?

Relaterte artikler

How to Backup your MySQL DB databases

Backup command for mysql databases For those looking to get a regular backup of your MySQL...

How do I create a MySQL database in Cpanel ?

MySQL databases can be created through the cpanel control panel: Login to your control panel...

How do I create a MySQL database in Plesk ?

MySQL databases can be created through the plesk control panel: Login to your control panel...

How do I repair a damaged MySQL table, rebuild index or prepare for backup ?

It is always worth trying a repair of MySQL tables before backing them up to shrink the...

How do I create a MySQL Database in the Ensim control panel ?

To add a database (subject to hosting plan resources available) through your Ensim control panel:...

Powered by WHMCompleteSolution