Syntax error in FROM clause when connecting to Dreamweaver records

[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 Nurick]

John Vinson and Dirk Goldgar have responded to an identical question
from Pumpmerchant in microsoft.public.access , so if anyone here has
something to suggest it would be a good idea to do it there rather than
here.

Pumpmerchant, next time you need to post a question in more than one
group please do it by crossposting one message to both/all groups rather
than by posting separate messages. That way, everyone can see all the
answers and there's no wasted effort.

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