Hi guys,

Right now I develop a website that use Microsoft Access database. So, I've developed a database that store all my pics and videos. But when I tried to make a recordset (this is a command in Dreamweaver MX, as I use it to develop my web pages) to call the database, this error dialog window occured;

Microsoft ODBC Microsoft Access Driver
Syntax error in FROM clause

This never occured for other database I've developed before. So, can you figure it out whats wrong with it and how to fix it? Thanks in advanced.

11 Years
Discussion Span
Last Post by campkev

That means you have an error on your SQL statement. What is the code in your application that you're using for the recordset??


Do you mean this one?;

<a href="numdetails.asp?id=<%=(Recordset1.Fields.Item("id").Value)%>"><%=(Recordset1.Fields.Item("number").Value)%></a></font></div></td>


If you're letting Dreamweaver do the coding, then the other problem might be on the Table on your database... are you sure you have the table available on the database??

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.