By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,867 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

INformation Source for Web Based Access Applications

P: n/a
Hi:

Can someone tell me a good (not too technical) manual or guide for developing Access
applications to be used over the web. We expect to have a number of associates who will be
reporting time, and getting status information, from a web base Access application.

As far as my experience, I have developed a number of fully functional web sites (html)
and have developed a couple of Access applications (PC and server based), but have never
combined the two.

Advice much appreciated.

Regards

John Baker
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi John,

Find out which server the website will be running on. If it's IIS, then you
can do the whole thing using ASP (or ASP.NET - download WebMatrix or get it
off a cover disk) writing VBScript/JavaScript that does the work then asks
ASP to spit out the HTML that makes the pages. If not IIS, you might have
to get to grips with PHP. Whichever way, you basically use ADO or a flavour
of ODBC to create connections back to the database on the server and play
around with the data using recordsets and commands.

There are loads of fine websites with ASP tutorials. If you're happy
writing VB/VBA, then the scripting that you'll need to use will be familiar,
even if the debugging is harder. If it's an app that needs to be secure
(they all are!) then make sure that you parse any user input as it comes in
to catch any malicious SQL Insertion attacks or script redirection attacks.
It's not to hard to do. I suggest that you start searching with Google for
some tutorials, and you should soon be underway.

Good luck

Andrew

"John Baker" <Ba******@Verizon.net> wrote in message
news:nf********************************@4ax.com...
Hi:

Can someone tell me a good (not too technical) manual or guide for developing Access applications to be used over the web. We expect to have a number of associates who will be reporting time, and getting status information, from a web base Access application.
As far as my experience, I have developed a number of fully functional web sites (html) and have developed a couple of Access applications (PC and server based), but have never combined the two.

Advice much appreciated.

Regards

John Baker

Nov 12 '05 #2

P: n/a
Andrew:

Thanks -- its going to be an interesting experience.

Regards

John

"Andrew" <an**************@webster.org> wrote:
Hi John,

Find out which server the website will be running on. If it's IIS, then you
can do the whole thing using ASP (or ASP.NET - download WebMatrix or get it
off a cover disk) writing VBScript/JavaScript that does the work then asks
ASP to spit out the HTML that makes the pages. If not IIS, you might have
to get to grips with PHP. Whichever way, you basically use ADO or a flavour
of ODBC to create connections back to the database on the server and play
around with the data using recordsets and commands.

There are loads of fine websites with ASP tutorials. If you're happy
writing VB/VBA, then the scripting that you'll need to use will be familiar,
even if the debugging is harder. If it's an app that needs to be secure
(they all are!) then make sure that you parse any user input as it comes in
to catch any malicious SQL Insertion attacks or script redirection attacks.
It's not to hard to do. I suggest that you start searching with Google for
some tutorials, and you should soon be underway.

Good luck

Andrew

"John Baker" <Ba******@Verizon.net> wrote in message
news:nf********************************@4ax.com.. .
Hi:

Can someone tell me a good (not too technical) manual or guide for

developing Access
applications to be used over the web. We expect to have a number of

associates who will be
reporting time, and getting status information, from a web base Access

application.

As far as my experience, I have developed a number of fully functional web

sites (html)
and have developed a couple of Access applications (PC and server based),

but have never
combined the two.

Advice much appreciated.

Regards

John Baker


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.