|
 |
access thread: Putting Access database on the web
Message #1 by Miriam Engelberg <MiriamE@c...> on Tue, 29 May 2001 10:57:41 -0700
|
|
I would like to learn how to put a simple (but relational) Access database
on the web. I will probably want to use Active Server Pages as the
middleware, but I am open to other suggestions. The problem is knowing where
to start. When I go on the web to get information, I find lots of general
information, but nothing step by step to get me started. Suggestions? Thanks
in advance...
Miriam Engelberg
Technology Faculty/Chief Cartoonist
CompassPoint Nonprofit Services
www.compasspoint.org
(xxx) xxx-xxxx
Message #2 by "Silas Wild" <SILAS@d...> on Tue, 29 May 2001 13:18:58 -0700
|
|
I believe there is a WROX press book entitled Web Databases. Let me know
if you have trouble finding this title on the wrox website, Barnes &
Noble, or Amazon.
>>> MiriamE@c... 05/29/01 10:57AM >>>
I would like to learn how to put a simple (but relational) Access database
on the web. I will probably want to use Active Server Pages as the
middleware, but I am open to other suggestions. The problem is knowing
where
to start. When I go on the web to get information, I find lots of general
information, but nothing step by step to get me started. Suggestions?
Thanks
in advance...
Miriam Engelberg
Technology Faculty/Chief Cartoonist
CompassPoint Nonprofit Services
www.compasspoint.org
(xxx) xxx-xxxx
Message #3 by Dean Pan <dpan999@y...> on Tue, 29 May 2001 13:57:44 -0700 (PDT)
|
|
You can try to use
browser-->internet/intranet-->web_server(tomcat)-->JSP-->DB(access)
get a copy of wrox's professional JSP which is helpful.
Dean
--- Miriam Engelberg <MiriamE@c...> wrote:
> I would like to learn how to put a simple (but relational) Access database
> on the web. I will probably want to use Active Server Pages as the
> middleware, but I am open to other suggestions. The problem is knowing where
> to start. When I go on the web to get information, I find lots of general
> information, but nothing step by step to get me started. Suggestions? Thanks
> in advance...
>
> Miriam Engelberg
> Technology Faculty/Chief Cartoonist
> CompassPoint Nonprofit Services
> www.compasspoint.org
> (xxx) xxx-xxxx
>
>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
Message #4 by Ken Clark <clarkk@w...> on Tue, 29 May 2001 14:09:40 -0700
|
|
I've been working with Access 97 and ASP to do this, the problem I ran into
is that if Access has the tables open, the data is locked and the ASP
cannot access it.
I'm in the middle of porting the Access tables to SQL Server 2000 now,
because we use an Access front end all day long (so the tables are open
often....)
At 5/29/2001 , you wrote:
>I would like to learn how to put a simple (but relational) Access database
>on the web. I will probably want to use Active Server Pages as the
>middleware, but I am open to other suggestions. The problem is knowing where
>to start. When I go on the web to get information, I find lots of general
>information, but nothing step by step to get me started. Suggestions? Thanks
>in advance...
>
>Miriam Engelberg
>Technology Faculty/Chief Cartoonist
>CompassPoint Nonprofit Services
>www.compasspoint.org
>(xxx) xxx-xxxx
>
Message #5 by "Craig Flannigan" <ckf@k...> on Wed, 30 May 2001 08:48:39 +0100
|
|
Hi,
You need to know what size of audience you are intending to use your
application.
If it's small, then you can set up a Server on your own PC. Typically, this
Microsoft Personal Web Server. This can host around 10 people on a machine
before performance becomes an issue.
If you are going to get a lot of people on it, or will be spending a lot of
time using it, consider getting a dedicated Windows NT 4, or Windows 2000
Server. This is designed for the job.
There are 3 things you need:
1. A server.
2. Your Database
3. The ASP Code to read the database.
This really is in simple terms.
If you tell me more about the situation, then my advice can be more
specific.
Regards,
Craig.
-----Original Message-----
From: Miriam Engelberg [mailto:MiriamE@c...]
Sent: Tuesday 29 May 2001 18:58
To: Access
Subject: [access] Putting Access database on the web
I would like to learn how to put a simple (but relational) Access database
on the web. I will probably want to use Active Server Pages as the
middleware, but I am open to other suggestions. The problem is knowing where
to start. When I go on the web to get information, I find lots of general
information, but nothing step by step to get me started. Suggestions? Thanks
in advance...
Miriam Engelberg
Technology Faculty/Chief Cartoonist
CompassPoint Nonprofit Services
www.compasspoint.org
(xxx) xxx-xxxx
Message #6 by SinghToor@a... on Wed, 30 May 2001 09:04:03 EDT
|
|
Hi Miriam:
you can use either ASP or Java to do that. But my suggestion will be that
if you are doing it on
Access then go with ASP. It will be easy to
program and the platform will be the same.
Also there is a book by wrox "Beginning Active Server Pages 3.0".
It will help a lot
Harpreet.
(xxx) xxx-xxxx
|
|
 |