Query a Database

[Susan]

I followed FP article 278613 How to Query a Database by
Using Multiple Criteria with a Drop Down Menu and it
worked fine. Now, I want to use my own access database.
I've tried to create the database connection instead of
using the Northwind sample. The mdb is located on the
server, and it appears to be connecting, but then I get
an error that says it can't find the Record Source list.
Any help would be appreciated.

 

[Guest]

Please state the exact error message you're receiving, and what's in the page
that creates the message.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Susan]

First, I'm using xp home edition which may be why I can't
get this working. I want to create a searchable
database. I followed the article ID 278613. These
instructions require you to make an empty web on the
server. When I do this, I go in the asp results page
that I made, and cannot make a new database connection.
The mdb is on the server, but I don't see it when I
browse for the connection. It works fine with the
northwind sample though. Since this didn't work the way
I needed it to, I tried to make the web locally & insert
the database and that will indeed display the data;
however, when I do try doing this (insert the database)
and select criteria for a search, the message says there
are no fields. Soooo, I'm wondering if I need the PWA
feature available on xp professional to create this
locally and upload it since I'm using an access
database.

 

[Thomas A. Rowe]

1. Your live site must be hosted on a Windows IIS server with FP extensions and the ability to use
ASP and Access. Check with your host.

2. To test locally you must have Windows 2000 Pro or Windows XP Pro with IIS installed.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Susan]

I do have is hosted correctly. asp query search pages
work using the northwind sample database. They don't
work when I use my own database. I followed the FP
article 278613, except I made a new connection & used my
database and a search field. The results don't appear,
no records found. I tried this entire thing without
using criteria and al the records appeared. So, I don't
know what the problem with the query is about. I'm
wondering if this article only pertains to using the
northwind sample.

-----Original Message-----
1. Your live site must be hosted on a Windows IIS server

with FP extensions and the ability to use

ASP and Access. Check with your host.

2. To test locally you must have Windows 2000 Pro or

Windows XP Pro with IIS installed.