Retrieving Access Database Results

[scking]

I recently attempted to use the insert database results wizard unsuccessfully. I create a connection, select the table and fields, and FrontPage inserts the table into my page BUT no data. I had pasted the database into my FrontPage web and followed the wizard to build the connection so everything looks great, but not data.

I know that there is data in the Access table and the query uses the wildcard * to return all results from the table.

Steve King

 

[diana5]

Hi Steve-

You need to have verified the database connection first. I had the same problem and once I verified it worked fine.

What you do is the following:

-Select TOOLS from the menu bar
-Select Web Settings
-Press Database tab
-Click on Database connection name and press Verify button

Repeat setting up your database results using the wizard.

Hope that helps-