< XXXX@XXXXX.COM > wrote
> Perhaps my original post was a bit
> misleading. This is not a company
> critical application; it is one research
> tool amongst dozens given to
> examiners and service representatives.
> It is important only to my small
> department and the goals my manage-
> ment has set. It will be a useful,
> but not absolutely critical, research tool.
> ... Is this something that could easily be
> accomplished with MS FrontPage or
> Macromedia Dreamweaver? I wasn't
> sure if those software packages contained
> ready made tools to link to an Access database.
It is hard to say with no more information about the application than you
have given, and without knowing more about your skills.
If their use of the application is sufficiently simple, it could be done
with Front Page and the Data Interaction Wizard (FP 2002 or 2003). But
simple interaction is a key phrase here -- nothing very complicated.
As far as I know, Dreamweaver has no intrinsic ability to access an Access
database, but someone who's more familiar with it than I may know of an
ASP.NET will use one of the Object-Oriented languages, probably either
VB.NET or C#. If you are not already a programmer, then that is likely to be
a "stretch". Traditional .asp pages are likely to be somewhat easier to
learn and implement.
Developer Editions of Access 97 are not easy to find, and not inexpensive
when you find them -- but a visit to the online auction sites would be
worthwhile IF all users will be on a LAN. If you are able to purchase a copy
and you choose that approach, thirty concurrent users is not asking a great
deal of Access, if the application is well-designed and well-implemented.
Tony Toews' website, http://www.yqcomputer.com/
FRIEND -- it has the best collection of multiuser performance and
corruption-avoidance links and information I know about.
Interesting that they can't afford to hire someone who could whip out what
you need in a few hours or a few days, but can afford to devote your time to
such a project for nearly two full months. I'm wondering how many copies of
Access 97 they would need so you didn't have to face even the learning curve
of the Developer Edition? I have seen Office Pro 97 for as little as $50 at
computer sales events (and, it certainly appears to be genuine... it is
three-releases-back obsolescent, after all, even if many of us still like it
as a developer tool).
Microsoft Access MVP