Syntax error in FROM clause

[Guest]

Hi, please could someone out there who knows what they are talking about help
me - I am reaching the end of the road both in terms of my own sanity and in
the avenues of inquiry that I can go down. I am working with Dreamweaver 8
and Microsoft Access 2003 - when I try to insert a recordset into a frame
that is connected to Microsoft Access it comes up with an exceptionally long
error message the main line of which is -1:[macromedia][sequelink JDBC
driver][ODBC socket][Microsoft][ODBC microsoft access driver] syntax error in
FROM clause. From my lines of enquiry so far I have (I think) worked out that:

This is a problem related to Microsoft Access and not Dreamweaver
The error is not related to the field names as I have tried all kinds of
different combinations of names and still to no avail
The database in not trying to link to a password field

I am a relative novice at all this, if anyone knows anything I wll be
eternally grateful.

Many, many thanks in advance

 

[John Vinson]

Hi, please could someone out there who knows what they are talking about help
me - I am reaching the end of the road both in terms of my own sanity and in
the avenues of inquiry that I can go down. I am working with Dreamweaver 8
and Microsoft Access 2003 - when I try to insert a recordset into a frame
that is connected to Microsoft Access it comes up with an exceptionally long
error message the main line of which is -1:[macromedia][sequelink JDBC
driver][ODBC socket][Microsoft][ODBC microsoft access driver] syntax error in
FROM clause. From my lines of enquiry so far I have (I think) worked out that:

This is a problem related to Microsoft Access and not Dreamweaver
The error is not related to the field names as I have tried all kinds of
different combinations of names and still to no avail
The database in not trying to link to a password field

I am a relative novice at all this, if anyone knows anything I wll be
eternally grateful.

Many, many thanks in advance

Any chance that you could post the FROM clause, or the whole SQL
string? It's more than a bit difficult to guess what might be wrong
with the FROM clause when we can't see it!

John W. Vinson[MVP]

 

[Dirk Goldgar]

Hi, please could someone out there who knows what they are talking
about help me - I am reaching the end of the road both in terms of my
own sanity and in the avenues of inquiry that I can go down. I am
working with Dreamweaver 8 and Microsoft Access 2003 - when I try to
insert a recordset into a frame that is connected to Microsoft Access
it comes up with an exceptionally long error message the main line of
which is -1:[macromedia][sequelink JDBC driver][ODBC
socket][Microsoft][ODBC microsoft access driver] syntax error in FROM
clause. From my lines of enquiry so far I have (I think) worked out
that:

This is a problem related to Microsoft Access and not Dreamweaver
The error is not related to the field names as I have tried all kinds
of different combinations of names and still to no avail
The database in not trying to link to a password field

I am a relative novice at all this, if anyone knows anything I wll be
eternally grateful.

Many, many thanks in advance

It appears to be due to a syntax error in the query you're trying to
execute; an error which is in the FROM clause of the query, or at least
appears to the SQL parser to be in that clause. Did the error message
include the SQL of the query, or can you extract that from your code?
If you post the SQL statement, we can probably spot what's wrong with
it.

 

[John Nurick]

A little googling suggests that a possible cause is spaces or special
characters in field names, table names or paths in the SQL statement.

Make sure that paths containing spaces are properly quoted. This may be
useful:
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForAccess

In general, IMHO, it's best not to use spaces or special characters in
names of tables and fields.

Hi, please could someone out there who knows what they are talking about help
me - I am reaching the end of the road both in terms of my own sanity and in
the avenues of inquiry that I can go down. I am working with Dreamweaver 8
and Microsoft Access 2003 - when I try to insert a recordset into a frame
that is connected to Microsoft Access it comes up with an exceptionally long
error message the main line of which is -1:[macromedia][sequelink JDBC
driver][ODBC socket][Microsoft][ODBC microsoft access driver] syntax error in
FROM clause. From my lines of enquiry so far I have (I think) worked out that:

This is a problem related to Microsoft Access and not Dreamweaver
The error is not related to the field names as I have tried all kinds of
different combinations of names and still to no avail
The database in not trying to link to a password field

I am a relative novice at all this, if anyone knows anything I wll be
eternally grateful.

Many, many thanks in advance