Without using a database, the best way is to create 30
subwebs and give each manager the authority to update a
different subweb. Of course, this also requires setting up
a user account for each manager, and making sure each
manager has FrontPage or some other way of creating Web
pages.
With a database, you would have to decide in advance what
kind of information the managers will enter: team rosters,
practice times, whose turn to bring the treats, whatever.
Then you design one or more database tables to contain
that information, and a table containing one record for
each manager.
You would have to write ASP or ASP.NET Web pages for
manager login, for managers to insert, change, and delete
information, and for display. Each record that contained
such data would also contain the applicable team number.
You may also want to create Web pages you (or the league
president) would use to add, change, or delete manager
information.
The manager login page would match a username and password
against values in the manager table, and if that succeeds,
the application would save the manager ID and the
manager's team number in a so-called Session variable. The
team update pages would then check to see that someone was
logged in, and refuse to operate if no one was.
The team update pages would get the team number from the
Session variable that resulted form the login. This
ensures that each manager only update record for his/her
team.
There would be some additional complexities if the same
person can manage two teams. Specifically, after a manager
logged in, you would have to offer a choice of teams to
update.
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)
|/---------------------------------------------------
*----------------------------------------------------
>-----Original Message-----
>Does FP2003 have any special controls that would make it
easy for the
>general public to update. I have a soccer site that I
would like for the
>managers to input their teams information. I have
approximately 30-40
>managers. What would be the best way to provide
passwords to the managers
>to allow them to have their own (single) page linked to
the main website.
>
>Is this possible?
>I don't currently use a database and not to familiar
connecting one. I can
>read up on it if it is the best way. I still don't
understand how each of
>the managers can update their page to a server.
>
>I need to understand the theory first???
>
>
>.
>
Similar Threads
