In Dreamweaver 8, when I go to set up a recordset, in the recordset dialog box,
the "table" dropdown box indicates a path to the table in the database,
instead of listing all the tables in the database.
ie
C:\CFusionMX7\wwwroot\websites\mannsUpdaterServer\ vehicles\mannsphotos.tblphotos

This did not happen to me in any previous Dreamweaver from UltraDev to MX2004.

What do I do to configure Dreamweaver (or possibly Coldfusion) to show the
tables of the database in the table dialog box instead of the path?

The SQL that Dreamweaver writes should look like this:
<cfquery datasource="mannsphotos">
UPDATE tblphotos
SET Subject=

Not this:

<cfquery datasource="mannsphotos">
UPDATE
C:\CFusionMX7\wwwroot\websites\mannsUpdaterServer\ vehicles\mannsphotos.tblphotos
SET Subject=

Your help is greatly appreciated
Thank you,
Barry