Database Interface Wizard-No Database editor page or submission fo

[Darla]

In FronPage 2003 SP2 I have built a web site that contains about 15 sub webs
that connect to my SQL server and displays SQL views. I am using the
Database Interface Wizard to create another connection to a SQL view that
need the users to be able to update the information and submit new
information. This view contains only one table. The permissions on the view
and the table are to allow select and update (no delete).

When I use the wizard I go through all the steps with no problem until the
last page where the only page that it will create is the results page. The
options for the submission form and database editor are grayed out and not
available.

I used this feature before in this same web site. Why is it not available
anymore? and how do I get it back?

I even tried creating a whole new site and get the same problem where it
will only create the results page.

Please help. i am going crazy here.

Darla

 

[Kathleen Anderson]

Hi Darla:
I haven't used SQL or SQL views, but I have used Access Queries as Views in
the Database Results Wizard. If you use an Access Query as a View in the
DBRW, there is no way to modify the SQL - you are limited to what you coded
in the Access Query.

I wouldn't think a View would give you the ability to do updates, which may
be why the Database Interface Wizard is not creating those pages for you.

Can you try using a Table as input to the DBIW instead and see if it works?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others