Large Database Applications

[Brad]

I'm using FP2K2 to write an asp based web application. I
have a database imported into my web that contains about
a dozen or so tables.

When I use the database interface wizard, it asks me to
specify login information as well as what tables I would
like to use when using the wizard. That's pretty easy
from a coding perspective - nice and slick.

Now - Here's the tough part:
I want users to be able to edit all the tables in the
database. So, if I need to use this wizard once each time
the table runs, will my users have to log-in and identify
themselves for each different table they have? How would
I build a menu that gives options for editing many
records at a time without asking the user to log in each
time?

For instance:
suppose a user needs to add information about a new
person in our organization, and they also need to add
some information about a new vehicle we have in
inventory. Obviously, I'd need to run the wizard twice,
once for each table. But, can I make a "master menu" that
a user could bounce around different database editing
pages that work on different tables without logging in?

Is there an easier way to do this?

Please reply to Brad_Hines at MSN dot COM

-Brad

 

[Jim Buyens]

This is really beyond what the Database Interface Wizard
was intended to do. Generally, people with applications
this complex write their own program code in ASP or
ASP.NET, and this gives them the flexibility to provide
whatever kind of editing, security, or organization they
want.

If all you want is a single password, though, I would set
up a new subweb, remove anonymous access, and then assign
*no* passwords when you run the Database Interface Wizard.
That way, the visitors will log into the entire subweb,
and not just one Database Interface.

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)
|/---------------------------------------------------
*----------------------------------------------------