I am trying to connect to an Access database using Dreamweavers'
Database and Bindings features but am running into a snag.

I am using my computer as a localhost web server using IIS running
under Windows XP.

In Dreamweaver, I can connect to my test database successfully. But
when I try to use Bindings to create a recordset query I get an error
msg that says "Unable to retrieve tables from this connection." If I
right-click on my test database and select 'Test Connection'
Dreamweaver can connect to it.

I know my test database is populated with tables. If I open up the
database I can see the tables are there.

I can also manually code in the database connection and recordset query
and the page will work.

Here's the connection code:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_conn_newland_STRING
MM_conn_newland_STRING = "dsn=newland;"
%>

.... and here's the recordset query:

<%
Dim rs_tourprices
Dim rs_tourprices_numRows

Set rs_tourprices = Server.CreateObject("ADODB.Recordset")
rs_tourprices.ActiveConnection = MM_conn_newland_STRING
rs_tourprices.Source = "SELECT tourID, tourName FROM tbl_tours ORDER BY
tourName DESC"
rs_tourprices.CursorType = 0
rs_tourprices.CursorLocation = 2
rs_tourprices.LockType = 1
rs_tourprices.Open()

rs_tourprices_numRows = 0
%>

Like I said above, this code works on the page, but Dreamweave doesn't
see the tables so the "Bindings > Recordset(query)" function doesn't
work.

Any ideas where I should look to fix this?

Thanks, everyone.