pages from database?

G

Glenn

I have a Microsoft Access database that has a list of my employees and
departments in it.

I have a site for each of my department's.

I'd like to have a page on there that lists the employees of the department.
I'd like to have that list come from my Access database - just showing that
department.

I'd also like the list to update automatically when I add new employees.

Is this possible using Front Page & Microsoft Access?

Thanks in advance.
 
T

Thomas A. Rowe

Yes. Use the FP database components, however your site must be hosted on a Windows IIS server.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
G

Glenn

I am running a Windows 2000 server. Is there anything additional I need to
do to it?

Also, are there instructions somewhere on how I can create the filter so
that only a specific department shows up? Or, do I just do that in Access?
 
G

Glenn

Oops. I should have tried it before I asked. I'm all set with that
question, but I have a new one:

Is there a way, for instance, of setting up a main page that allows the web
user to select what they want to search by? Such as a pull down list of
departments?

I have tried this and can't figure it out.
 
T

Thomas A. Rowe

The database components will allow you to set the filter for what records are to be returned, just
go thru the wizard after you have imported the database into the web, and created the connection.

I can't really help you beyond the basics with the FP database component, as I only do hand coding.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
J

John Prescott

I would not attempt to write this with a FrontPage wizard. It would
best be done programatically which means that you would probably have
to outsource it. To assess viability, how many staff and departments
do you have?

Regards, John Prescott

Paymaster Systems Ltd,
Moorlands House, Oldfield Road, Bromley, Kent. BR1 2LE
TEL: 020 8467 6107 FAX: 020 8467 6121
e-mail: [email protected] website <http://www.oursite.co.uk>
 
C

Clark

Are you kidding? FrontPage was *made* for this kind of thing. It's a simple
application, he wants to do it himself and is already part way there. He surely
does not need to outsource it.

And besides, Kathleen has him covered!
 
Top