Web developers notes,programming tutorials.

Syntax error in FROM clause
This commonly occurs when you have a table name that is a reserved word or your table name contains a space

(eg “table 1″).

Certain words (like table, field, date, select, password, level etc) are reserved by either ADO, OLEDB or by Access

for use as commands or system objects.

You should never use these words as names for tables or fields nor should you have spaces in your tablenames. It

is recommended that you rename your offending tables/fields and adjust your SQL statement accordingly.

If this is not possible you should enclose your offending table names with [ ] marks, eg

SELECT field1
FROM [table]

Syntax error in INSERT INTO statement.
This commonly occurs when your field name is a reserved word (see scenario 1 above). Adjust your field names and

SQL statement accordingly and you should avoid the problem.

If you can’t adjust your fieldnames you can use [ ] marks to delimit the field names, eg

INSERT INTO table1
([field], [password])
VALUES (’value1′, ‘value2′)

This entry was posted on Wednesday, January 24th, 2007 at 3:49 pm and is filed under asp development, ms access database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.