web database advice desired

P

Peter Dahl

Folks,
looking for some advice on the best way to tackle this. I
currently have an app that's soon to be unsupported as we finish
converting to XP and Office XP. The app is a tool for my team to use
in determining the appropriateness of catalog elements. It was
developed in an older version of Access and has multiple data views.
There are about 8 "windows" stacked together that present data, with
selections from a previous affecting the next.
Window 1 contains Nouns.
Window 2 contains Modifiers and becomes active and displays relevant
modifiers when a Noun is selected.
Window 3 contains explanations of each modifier, which becomes active
and displays the correct record whn a modifier is selected
Window 4 contains synonyms, if found, for the noun (if the noun window
is active) or the modifier (if the noun is selected and the modifier
is active).
ETC
In other words, all the windows are related (via relationships in the
database) and become active after selections are made and the field
narrowed.

Now, the advice ... the team not only needs the tool but wants to make
it available to our "customers" (internal service requesters) ...
through our intranet website.

Would I be better off pursuing an ADO type web application, or
rebuilding the application in Access XP and just providing a link? Do
any of the web database products have that functionality? Should I be
looking at VBA? or?

thanks in advance.

peter
too bad common sense isn't
 
C

clintonG

I think it would be better to ask this type of question at
news://microsoft.public.inetserver.asp.db or another
similar newsgroup where you will find more people with
more experience with database design and deployment issues.

If it were me though, I would consider upsizing to SQL Server
or a named instance of MSDE. I would rebuild the user interface
as a web application. I would be using Visual Basic.NET or C#
and I would be learning how to deploy the extranet access via
SharePoint Services.

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top