VBA and ASP

[Visitor No 3]

My local Crinklys group(U3A) want me to develop a noddy database and web
site for their members. Some are computer literate, others not so. I thought
an Access 2000 mdb on a server from the local council with a web page in
Active Server Pages(ASP) and using ADO would do the trick then one of them
could update it at home on the web to keep track of members and somebody
else could do the same for current programmes etc. The Chair Person could
then use all the data in the DB to keep track of things, such as sending
letters out to members, by accessing the DB directly over the Internet from
the council server as an application rather than a web page. Nothing
arduous.

I have developed the odd Access Application in VBA but I have never used VB
or VBScript, which seem to be the tools for ASP.

My question, before I start, is: Is this a sensible route to take and my
other question is: Can ASP be programmed in VBA, with which I am familiar.

Thanks.

 

[J Doe]

Access isn't a great choice for a web app, maybe if only a couple of people
were updating it concurrently but it's still not great.

ASP is very VBA-like and it is a really simple but powerful language. If
you are a good/advanced VB/Access VBA coder and understand web technologies,
you should be able to do this although it will not be a cake walk. Things
you are used to doing really easily using Access take a lot of hand coding
to do in a web page, and the automated tools for doing this produce junk
code.