Access Dbase Best Practice For Implementing On Intranet

[JCrowe]

Hi,
I have contructed an access database to track montly
expenses for a small department. Total records input for
the year will be appx 5000. I would like to place the
Access database on the intranet for all members of the
department ot use. My question is what is the best way to
accomplish this ? I am unsure of how (or even if)Access
2000 will accomplish this. Presently I am thinking of
simply constructing an input form thru FrontPage to allow
users to update and then use the DRW to create reports.

I havent started testing any of these ideas yet I wanted
to get some input from the group before I go in a circle.
I have listed below the specs and info you may need to
decide.

Using MS FrontPage and Access 2000
IIS 5.0 Server - ASP pages work fine on Intranet with FP
Extentions installed.
Access Database:
3 Tables
10 Queries
10 Reports
1 SwitchBoard
0 Macros

Thanks,
JCrowe

 

[Jim Buyens]

-----Original Message-----

Hi,
Howdy.

I have contructed an access database to track montly
expenses for a small department. Total records input for
the year will be appx 5000. I would like to place the
Access database on the intranet for all members of the
department ot use. My question is what is the best way to
accomplish this ...

You can certainly add the Access database to a FrontPage
Web, but any forms or reports you created in Access won't
work over the Web. You would need to create ASP or ASP.NET
pages for whatever processing you require.

The FrontPage Save Results component can insert records
one at a time from an HTML form.

The FrontPage Database Results Wizard can create tabular
displays, including sorting and selection criteria.
However, it doesn't support control breaks or subtotals,
and its column formatting is just about nil.

There's a Database Interface Wizard that can generate
Query, Add, Update, and Delete pages for any table, but
security and data validation are minimal.

To go beyond what the FrontPage components provide, you
would need to do some programming in ASP or ASP.NET.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------