Database Interface Wizard-No Database editor page or submission fo

D

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
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top