473,396 Members | 1,963 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

INformation Source for Web Based Access Applications

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
2 1226
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: simonc | last post by:
I've been programming in assembler and C/C++ for a number of years, but I'm only just starting down the road of PHP & MYSQL. I have a couple of questions: (1) Before I start writing my own...
17
by: /dev/null | last post by:
I have some php-based software that I'd like to make available to some businesses that run on my web server (apache on Linux). These businesses have full access to all their web files. I'd like...
0
by: Unigroup of New York | last post by:
Content-Type: multipart/mixed; boundary="------------C465DF38DCB38DD2AF7117E0" Lines: 327 Date: Tue, 15 Feb 2005 23:36:38 -0500 NNTP-Posting-Host: 24.46.113.251 X-Complaints-To: abuse@cv.net...
115
by: TheAd | last post by:
At this moment I use MsAccess and i can build about every databound application i want. Who knows about a serious open source alternative? Because Windows will be a client platform for some time, i...
2
by: Kumar | last post by:
Hi Folks, I would like to develop one custom application using asp.net,C#,SQL server for tracking all our company servers. Most of the functionality is similar to HP Systems Insight Manager ...
0
by: tmsprowl | last post by:
Greetings! I was wondering if someone could help me with a problem I'm having. My department is just one of many within my organization. My organization has control over the network domain,...
0
by: Lester Knutsen | last post by:
A two-day IBM Informix and DB2 User Group Technical Conference - Friday and Saturday, December 8-9, 2006 Location - Fairview Park Marriott, Falls Church, VA (near Washington D.C.)...
3
by: adimangla | last post by:
Hi :-) I am creating a software that will save the present state of all the applications running on the desktop (WinXP). Can anyone point out the method to extract the filenames from the...
1
by: mdk7 | last post by:
I am very new to developing forms and queries with Access. The task that I am required to complete is as follows: Build a form based user interface that displays various information from the...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.