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
--
Darla

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



"Darla" <(E-Mail Removed)> wrote in message
news:45ED3FBC-EE2A-4379-AD3B-(E-Mail Removed)...
> 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
> --
> Darla