473,692 Members | 2,115 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

WEB Integration of Access Database/System

Hi:

I am URGENTLY in need of some book or web site OR tool that will help me integrate a
relatively simple access application into a web page or pages. This is a time recording
system (by project), and I would be more than wiling to pull the updated database down
from the Host using FTP on a monthly basis. Its just that I need to understand how to set
it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access 97 had a wizard that
permitted the creation of web pages, and wonder if that wizard is available as an add on
to other versions of Access.

Thank You

John Baker
Nov 13 '05 #1
8 3143
John,

Some questions...

*Does "urgent" mean that you need it done very quickly?

*Should users be able to input information as well as view information
from the web or is this simply for reporting purposes?

*Will the number of users increase as a result of publishing the
application to the web?

*Do you expect the web application to eventually replace the MS Access
application?

*Will the web server be located on your network or will you use a third
party hosting service?

Bill Ehrreich
Hollywood, FL

John Baker wrote:
Hi:

I am URGENTLY in need of some book or web site OR tool that will help me integrate a relatively simple access application into a web page or pages. This is a time recording system (by project), and I would be more than wiling to pull the updated database down from the Host using FTP on a monthly basis. Its just that I need to understand how to set it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access 97 had a wizard that permitted the creation of web pages, and wonder if that wizard is available as an add on to other versions of Access.

Thank You

John Baker


Nov 13 '05 #2
John,

Some questions...

*Does "urgent" mean that you need it done very quickly?

*Should users be able to input information as well as view information
from the web or is this simply for reporting purposes?

*Will the number of users increase as a result of publishing the
application to the web?

*Do you expect the web application to eventually replace the MS Access
application?

*Will the web server be located on your network or will you use a third
party hosting service?

Bill Ehrreich
Hollywood, FL

John Baker wrote:
Hi:

I am URGENTLY in need of some book or web site OR tool that will help me integrate a relatively simple access application into a web page or pages. This is a time recording system (by project), and I would be more than wiling to pull the updated database down from the Host using FTP on a monthly basis. Its just that I need to understand how to set it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access 97 had a wizard that permitted the creation of web pages, and wonder if that wizard is available as an add on to other versions of Access.

Thank You

John Baker


Nov 13 '05 #3
bi********@nets cape.net wrote:
John,

Some questions...

*Does "urgent" mean that you need it done very quickly? It means that I need to get it done in the next few months, at as low a cost a possible,
and uncertain about the right way to go about it at the moment..

*Should users be able to input information as well as view information
from the web or is this simply for reporting purposes?
It is a time collection application, so YES users will be putting in data (time by day by
project).
*Will the number of users increase as a result of publishing the
application to the web?
The number will increase modestly (20-40) but as a result of organizational growth, not as
a result of the web application.
*Do you expect the web application to eventually replace the MS Access
application?
NO the web application is a feed to a back end Invoice and Payroll Access application. We
currently use an Excel spreadsheet, running on individual systems, combined with e-mail.
*Will the web server be located on your network or will you use a third
party hosting service?
3rd Party Host.

Bill Ehrreich
Hollywood, FL

John Baker wrote:
Hi:

I am URGENTLY in need of some book or web site OR tool that will help

me integrate a
relatively simple access application into a web page or pages. This

is a time recording
system (by project), and I would be more than wiling to pull the

updated database down
from the Host using FTP on a monthly basis. Its just that I need to

understand how to set
it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access

97 had a wizard that
permitted the creation of web pages, and wonder if that wizard is

available as an add on
to other versions of Access.

Thank You

John Baker


Nov 13 '05 #4
>>*Will the web server be located on your network or will you use a third
party hosting service?


3rd Party Host.


Well, since ms-access has really NOTHING to do with a web based system, then
it really does not mater what database you use on the web server...does it?
You might be able to find a web provider that supports the use of a
ms-access mdb file. All this means is that the software (the web software
YOU will have to write) will read data from the mdb file. However, for all
intensive purposes, you are NOT really using ms-access anymore. (the forms,
reports, Code are all useless in this case). So, for example, if that
provider supports the placing of a mdb file on their server, you STILL DO
NOT HAVE to install ms-access on that server. The only part that gets
installed on the web server is the JET database engine that allows the web
site to USE the data.

JET is the same data engine that VB6 developers, or .net developers use to
read, and write the mdb file format. So, really, you not using ms-access at
all anymore here (the web server only needs a way to read the data). Since
you are only reading (or updating) the data, and NOT using the application
part, then at the end of the day, you can use sql server, or MySql, or
whatever database engine that the web provider supports. Transferring data
from MS-sql server is likely LESS work then trying to pull data from a mdb
file sitting on that web server (and, to copy the mdb file, you will have to
shut down the web server which has the mdb file open. Further, shutting down
the web server can often be quite hard to do when you are using a web
hosting company...as you got to shut down THEIR web server so the mdb file
is closed, and then you can copy it. However, in all of these cases, and
EVEN when you are using a mdb file on the web server you are NOT using
ms-access in any way, shape, or form. If you use a server based engine like
ms-sql server, then you can connect to that database over the internet and
pull data from it into your mdb file...but you can't do that if you choose
mdb file to host the data on the server.

So, at the end of the day, your data on the server does not have to be in
ms-access, and in fact it is LESS of a advantage to place your data in a mdb
file for the web server to open and consume. And, since you are NOT using
any special features of ms-access/mdb files anyway, then do you really care
where, or what system is used on the web server to host the data?

To be fair, ms-access does have some web based ability, but they requite
TIGHT integration with the web server, and in fact is only practical if you
are running your own web server (along with the VERY scary security risks of
doing this!!). ms-access has what is called DAP's (data access pages). These
DAP's are in fact live connections to a mdb file. And, you can even create
forms in ms-access and save them as a web form (all the fears like sub-forms
etc DO NOT work). And, you still requite end users to have office installed.
So, DAP's are not at all practical for a public web site, and further you
would be MUCH better to use something like front page...and learn some
scripting (vb.script) to make ASP pages.

So, your best approach here is to build the web stuff in ASP, or even better
ASP.NET (and, you don't need ms-access to do this, nor will ms-access help
you anyway. Further, placing the data in a mdb file on a web server is
actually HINDRANCE for you to be able to use the data).

So, you will have to check with your web provider as to what kinds of
software tools and development tools THEIR web server supports. For example,
it might be that your provider is using non Microsoft based web servers, and
thus your choice of tools is limited.

Hence, you either have to find out what tools and development systems your
web provider supports, or choose the tools you want to crate your web stuff
with, and then find a provider that supports your favorite tools you are
(will) use to develop your web site. However, those tools have really noting
to do with ms-access at all. ms-access is not a web based system..and is the
wrong tool, and in fact will NOT help you at all here.

Time to start visiting some other (non ms-access) newsgroups here!!

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #5
John,

I don't see any way around creating a web application for this. Also,
as Albert says, there's no particular reason why you must use MS Access
(Jet) as the database, especially if the "back end Invoice and Payroll
Access application" does not yet exist. If your 3rd party host will
provide you with database tools such as MySQL or MS SQL Server (as mine
does) then you would be much better off using those with your new web
application.

In addition, you should think about security as this would be
senstitive information sitting on someone else's server going across
the web with HTTP. You might want to use SSL (very simple to do) and
some kind of authentication so that not just anyone can log in. You
may want to discuss security with your 3rd party provider. You also
may want to consider hosting this on your own server--talk to your
network admins about options.

If you have no experience with web applications then it may be a good
idea to hire someone to handle this. Of course, this could also serve
as a good crash course in web development for you if you're willing to
take on something completely new and have enought time to devote to it.

Bill

Nov 13 '05 #6

John Baker wrote:
Hi:

I am URGENTLY in need of some book or web site OR tool that will help me integrate a relatively simple access application into a web page or pages. This is a time recording system (by project), and I would be more than wiling to pull the updated database down from the Host using FTP on a monthly basis. Its just that I need to understand how to set it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access 97 had a wizard that permitted the creation of web pages, and wonder if that wizard is available as an add on to other versions of Access.

Thank You

John Baker

This software should help you:

http://web.peoriadesignweb.com/database

Nov 13 '05 #7
sq****@peoriade signweb.com wrote:
John Baker wrote:
Hi:

I am URGENTLY in need of some book or web site OR tool that will help


me integrate a
relatively simple access application into a web page or pages. This


is a time recording
system (by project), and I would be more than wiling to pull the


updated database down
from the Host using FTP on a monthly basis. Its just that I need to


understand how to set
it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access


97 had a wizard that
permitted the creation of web pages, and wonder if that wizard is


available as an add on
to other versions of Access.

Thank You

John Baker


This software should help you:

http://web.peoriadesignweb.com/database

You first need to figure out where you can host the application and if
they support ASP pages and/or ASP.NET pages? That is key as to which
software you can use. If your web site does not support either of the
above, then I can't advise you very much.

I never had any luck with the built in ASP generation within Access.

If it does support ASP only, and you have a relatively straightforward
set of pages to construct, then I suggest you use FrontPage. You can
import an access database to Frontpage. Its wizard will generate
add/change/delete pages for you. Not as integrated as Access (separate
pages for view, edit and delete - but it works).

Note you have to ensure that the directory you put your database into
using front page, when copied to the host web site, will get the
necessary permissions for updating the database. If not, you will get
an error "requires an updatable query" when doing changes, additions or
deletions; reading will work fine".

If you have a web host that will support Microsoft's new ASP.NET, then
you have more options.

One I like is called Raptier. It uses "grids" kind of like an access
database list display, to show the data. Not customized forms, but it
works well. Raptier lite is free.
http://www.sharppower.com/Default.as...=products/home

Another software I really like is Microtools Access Wiz - Access to .Net
converter. Cost is $135 but there is a free trial using the Microsoft
Northwind database.
http://www.microtools.us/

Easy and straightforward to run. Generates code quickly.

After conversion it opens the generated web site automatically (and
leaves the conversion program open).

You must have the free Microsoft .Net framework 1.1 installed to run the
software.

Very good, responsive support via email!!!

Hope this helps.

Bob
Nov 13 '05 #8
Bob Alston wrote:
sq****@peoriade signweb.com wrote:
John Baker wrote:
Hi:

I am URGENTLY in need of some book or web site OR tool that will help

me integrate a
relatively simple access application into a web page or pages. This

is a time recording
system (by project), and I would be more than wiling to pull the

updated database down
from the Host using FTP on a monthly basis. Its just that I need to

understand how to set
it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access

97 had a wizard that
permitted the creation of web pages, and wonder if that wizard is

available as an add on
to other versions of Access.

Thank You

John Baker



This software should help you:

http://web.peoriadesignweb.com/database

You first need to figure out where you can host the application and if
they support ASP pages and/or ASP.NET pages? That is key as to which
software you can use. If your web site does not support either of the
above, then I can't advise you very much.

I never had any luck with the built in ASP generation within Access.

If it does support ASP only, and you have a relatively straightforward
set of pages to construct, then I suggest you use FrontPage. You can
import an access database to Frontpage. Its wizard will generate
add/change/delete pages for you. Not as integrated as Access (separate
pages for view, edit and delete - but it works).

Note you have to ensure that the directory you put your database into
using front page, when copied to the host web site, will get the
necessary permissions for updating the database. If not, you will get
an error "requires an updatable query" when doing changes, additions or
deletions; reading will work fine".

If you have a web host that will support Microsoft's new ASP.NET, then
you have more options.

One I like is called Raptier. It uses "grids" kind of like an access
database list display, to show the data. Not customized forms, but it
works well. Raptier lite is free.
http://www.sharppower.com/Default.as...=products/home

Another software I really like is Microtools Access Wiz - Access to .Net
converter. Cost is $135 but there is a free trial using the Microsoft
Northwind database.
http://www.microtools.us/

Easy and straightforward to run. Generates code quickly.

After conversion it opens the generated web site automatically (and
leaves the conversion program open).

You must have the free Microsoft .Net framework 1.1 installed to run the
software.

Very good, responsive support via email!!!

Hope this helps.

Bob

Did some more recent looking at DAP pages. I now remember what turned
me off to them. that was the ability to do subforms with DAP. I use
sub forms extensively in my Access apps.

But that aside, for a simple form, the DAP generated code works.

And now, after all my research into all the other software, I have
learned a lot about how a web page accesses an Access database. On a
live server, you have to 1) know the real path to the Access database
and put that on the page; or code mappath commands correctly to
dynamically identify the location of the Access database. 'Cause the
web page opens the Access database using file access routines. That can
get a bit complicated but stay in there.

If you can use rather simple forms on your web site, you can generate
DAP pages and you certainly can FTP the database periodically to
retrieve the data that has been entered.

You can of course modify the DAP page via your own code. I think it
used HTM: and javascript.

Bob
Nov 13 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
4211
by: Rick Kopnisky | last post by:
I am unable to get the VSS Integration with InterDev to work after reading the Microsoft support articles and searching through the usenet using Google groups. I have read MS Knowledge Base Article - 171116 and enabled FrontPage logging as described in 191289 I am still getting the 'User "" not found' message in the event log on the web server even after enableing the "Use Netwrk name for automatic login" in VSS Administrator Here are the...
4
3588
by: Dan | last post by:
Hello all. I am currently working on a project for several Hospitals. The application is written in Java, and the database is either Oracle or MySql, depending on the client. For a while now, we have been asked to integrate our appliations database with the databases of the other Hospital applicatoins, such as payroll, scheduling and so on. I have been looking around online to see how others have done this, and I have come up with...
0
1683
by: Wayan | last post by:
Geekcorps Volunteer - Systems Integration Kenya, East Africa Geekcorps http://www.geekcorps.org is in search of systems integration professionals experienced in developing communication systems for border-related software. The volunteers will work in Kenya and Uganda to design an integration system that will link the immigration, police, customs, and cargo tracking systems of Kenya and Uganda at the Malaba border crossing.
3
5732
by: Kurt | last post by:
Hi We are developing an off-the-shelf software suite for a certain business sector. Most of the program is simply a GUI on top of some .mdb files. Its a .net application written in c# One major requirement is "Outlook Integration". The Outlook contact folders are to be used for contact management I want to know what is the standard way to do this these days. Most of the information in MSDN seems rather old I first used the Outlook...
0
2301
by: Stylus Studio | last post by:
DataDirect XQuery(TM) is the First Embeddable Component for XQuery That is Modeled after the XQuery API for Java(TM) (XQJ) BEDFORD, Mass.--Sept. 20, 2005--DataDirect Technologies (http://www.datadirect.com), the software industry leader in standards-based components for connecting applications to data and an operating unit of Progress Software Corporation, today announced the release of DataDirect XQuery(TM), the first embeddable...
2
1634
by: John Baker | last post by:
Hi: I have a small project pending where I need to have a data base on our ISPs server and a web interface to the database. At periodic intervals, I want to be able to either interrogate the data base from a local system OR have the web based system transmit an e mail containing critical database information. Its not a big project, but could get messy. Does anyone have a suggestions for the right package to use to integrate a small...
7
4007
by: MuZZy | last post by:
Hi, We are developing a CRM (Customer Relations Management) module for our app and my boss wants to provide integration with PBX (phone systems used by lots of companies) so that if a user gets a call, application pulls up caller's information from CRM database based on caller's phone number. I found several solutions like callerid.com which require to hookup some hardware to your phone and computer, but we wanted to make some generic
14
2576
by: Kevin G. Anderson | last post by:
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG Social When: Thursday, May 25, 2006, 6PM Who: Chris Monaghan and Kevin Anderson Where: The Information Management Group 200 W. Monroe St. Suite 900 Chicago, IL 60606 (312) 222-9400 Location: www.imginc.com/IMG/About+IMG/chicago.htm
10
1928
by: Scott M. | last post by:
I've seen many posts and ready articles discussing how changing the membership & roles "provider" in VS .NET is easy, but have yet to see instructions on how to do it. If I already have SQL Server 2000 on a machine and didn't install SQL Server 2005 Express with my VS .NET installation, how do I set up my existing SQL 2000 server to be the membership & roles provider for ASP .NET?
0
8604
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8538
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8800
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7627
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6459
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5819
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4324
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2974
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2238
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.