Database error...newbie..

[jma]

I am trying to create the recordset and when I click on the plus sign next to recordset icon I get...
Microsoft ODBC Error Microsoft Access Driver Syntax error in from clause....I give, no idea...too new at this to have any idea where to even look for what it is mad about...THanks all..M

 

[derren]

Hi

This happens when you "adjust" the code for the recordset in the code window. If DW can't read the code in the same format that it is used to you can't view the recordset in the data bindings panel. This can also happen if you have created the recordset without testing it first.

Go into the code and have a look at the recordset part to see. If it is an untested recordset, post the code and we'll fix it for you. Derren
[The only person in the world to like Word]