473,471 Members | 1,756 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Web based Access Applications

I've been developing Access databases for some time now and would like
to take the next step - web based systems.

What technology should I start exploring?

What software would I need? Instead of building a physical web server
to test on, could I use VMWare?

Any pointer would be helpful.

Thanks!

Nov 13 '05 #1
13 1351
I still like classic ASP for quick and dirty database driven web sites.
ASP is faster than ASP .Net for simple things and while it's virtually
spaghetti code, the process is straight-forward and can be done
entirely in Notepad.

http://www.databasejournal.com/featu...le.php/3487741

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast/

"BerkshireGuy" <bd*****@yahoo.com> wrote ...
I've been developing Access databases for some time now and would like
to take the next step - web based systems.

What technology should I start exploring?

What software would I need? Instead of building a physical web server
to test on, could I use VMWare?

Any pointer would be helpful.

Thanks!

Nov 13 '05 #2
Danny,

This is just what I was looking for. Something straightforward to get
my feet wet. I could use VMware to create a virtual web server
correct?

Thanks
Brian

Nov 13 '05 #3
I'm not sure what you mean by VMware. I just set up my Win 2000 Pro
or Win XP Pro machine with IIS, which supports ASP and VB Script.
If you mean you want to create a virtual server, then sure, that will
work, so long as it's loaded a Professional version of a Microsoft
Windows operating system.

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast/

"BerkshireGuy" <bd*****@yahoo.com> wrote ...
Danny,

This is just what I was looking for. Something straightforward to get
my feet wet. I could use VMware to create a virtual web server
correct?

Thanks
Brian

Nov 13 '05 #4
Danny,

Sorry.

VMware is a handy tool that allows you to create a "virtual machine."

Save for instance, your main machine was Windows Xp Pro. But for
testing purposes or whatever, you wanted to setup another machine with
Windows 2000 Professional. Instead of settiing up another physical
machine with Windows 2000, you could create a virtual machine using
VMware and install Windows 2000 on that.

http://www.vmware.com/

-Brian

Nov 13 '05 #5
I kind of thought so. Just be sure whatever version of the OS you
load has IIS on it. You may have to tweak a few things for the
web folder so that the global.asa page may be used to store session
variables. If you need help with that, email me and we'll take that
ASP part of the discussion offline.

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast/

"BerkshireGuy" <bd*****@yahoo.com> wrote ...
Danny,

Sorry.

VMware is a handy tool that allows you to create a "virtual machine."

Save for instance, your main machine was Windows Xp Pro. But for
testing purposes or whatever, you wanted to setup another machine with
Windows 2000 Professional. Instead of settiing up another physical
machine with Windows 2000, you could create a virtual machine using
VMware and install Windows 2000 on that.

http://www.vmware.com/

-Brian

Nov 13 '05 #6
BerkshireGuy wrote:
I've been developing Access databases for some time now and would like
to take the next step - web based systems.

What technology should I start exploring?

What software would I need? Instead of building a physical web server
to test on, could I use VMWare?

Any pointer would be helpful.

Thanks!

You might find of interest this summary of my travels down this road,
specifically for trying to utilize access databases on the web:

http://members.cox.net/tulsaalstons/...20Internet.htm
Bob

I like VMware for haven't used it for any of my web testing or development.
Nov 13 '05 #7
Hi All,

You can use VMWare or VirtualPC for anything - after all they are
virtual machines. VPC doesn't support USB peripherals and emulated
screen hardware may cause trouble with autodetection of Linux installs
but they're good if you want a test platform that does not sully your
desktop PC.

That having been said, there are more and more personal webservers now
that you can take for a drive with minimal install footprint or
tampering. Personal in that you have a development platform for testing.

e.g.

http://www.pablosoftwaresolutions.co...eb_server.html
http://dwebpro.com/
http://www.asp.net/Default.aspx?tabindex=6&tabid=41
http://www.badblue.com/

It would be good not to be open to Internet attacks (that installing a
webserver on your machine adds to your attack surface) so sitting behind
a cheap, simple NAT router or just not connecting to the real Internet
is good idea.

And although one would have considerable comfort to VBA in Access
desktop apps, it is not a given that one *has* to use a VB dialect for
web database delivery.

ColdFusion is so simple that one can produce something in an hour from
newbie status, php is the most common cost-less language. Classic ASP is
always there and there is ASP.NET.

Here's a page I wrote all those years ago (and haven't updated):
http://members.optushome.com.au/anandasim/asp.htm

HTH
Ananda

p.s.
Lot of research you did Bob!
Bob Alston wrote:
BerkshireGuy wrote:
I've been developing Access databases for some time now and would like
to take the next step - web based systems.

What technology should I start exploring?

What software would I need? Instead of building a physical web server
to test on, could I use VMWare?

Any pointer would be helpful.

Thanks!

You might find of interest this summary of my travels down this road,
specifically for trying to utilize access databases on the web:

http://members.cox.net/tulsaalstons/...20Internet.htm

Bob

I like VMware for haven't used it for any of my web testing or development.

Nov 13 '05 #8
Ananda Sim <An*******@gmail.com.invalid> wrote in
news:43***********************@news.optusnet.com.a u:
ColdFusion is so simple that one can produce something in an hour
from newbie status, php is the most common cost-less language.
Classic ASP is always there and there is ASP.NET.


I loved CF, but couldn't find anywhere to host it that didn't cost a
fortune.

So, I switched to PHP, which is much harder for me as an Access
developer, but still pretty easy.

Also, it's so nicely integrated with MySQL that it's very easy to
do, with lots of functionality, and pretty darned good documentation
for both.

Now, I'm no big fan of MySQL, but as a way of getting your feet wet,
Apache+PHP+MySQL is a pretty darned powerful development platform,
and is free from top to bottom. You can also run your testbed on
Windows and port the code to a production server running Linux or
whatever without having to worry about it.

The only things to worry about are version differences between your
testbed environment and the deployment environment. PHP in
particular is really bad about breaking working code with minor
point upgrades, so it's pretty important that you use the same
version.

I've explicitly never learned ASP because:

1. at the time I was choosing a server-side scripting language to
learn, NT-based hosting was more expensive than the alternatives.

2. it's intimately tied in with IIS, whereas PHP and CF, for
instance, can run on any web server.

3. I believe it's better for the software ecosystem to use multiple
plastforms in different environments. That means that I use non-MS
products wherever it's workable, and in the case of web development,
I think it's vastly preferable.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #9
Thanks Danny. I appreicate your offer to help and your advice!

-Brian

Nov 13 '05 #10
Danny, Bob, Ananda, and David. Thank you! This is great information
and will keep me busy for a little while at least!

Best wishes to all of you,

-Brian

Nov 13 '05 #11
I might recommend Python. The language looks a lot like BASIC, although
don't tell a Pythonista that. There are a number of web frameworks available
so a lot of the gruntwork is taken out of the picture. Python can connect
to Access Databases. Yes, there's a learning curve, but it looks like you
may be going that route anyway.

www.python.org

Some Frameworks available are:
http://www.cherrypy.org/
http://twistedmatrix.com
http://zope.org

and for a full overview of MOST of the frameworks see:
http://www.python.org/pycon/papers/framework/web.html

BTW. python is free, as in free beer and free lunch. Can be used as an
Object Oriented language, or as a functional language.

HTH
Ruben

"BerkshireGuy" <bd*****@yahoo.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
I've been developing Access databases for some time now and would like
to take the next step - web based systems.

What technology should I start exploring?

What software would I need? Instead of building a physical web server
to test on, could I use VMWare?

Any pointer would be helpful.

Thanks!

Nov 13 '05 #12
Thanks Ruben. Free can be good! :)

-Brian

Nov 13 '05 #13
my old client.. www.gorge.net had pretty reasonable CF hosting

Nov 13 '05 #14

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

Similar topics

3
by: Michael Crawford | last post by:
Hi, Where would one start for this type of application: I want to create an vb.net container application that has the gives the end user the ability to install and uninstall plugins or add-in...
1
by: CK | last post by:
Access2PDF is the software solution for developers looking for an easy way to include reports with their web based applications. http://access2pdf.com/ For many reporting requirements,...
2
by: John Baker | last post by:
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...
2
by: John Baker | last post by:
Hi: Can someone answer the following questions about "Pages" a. Are they are good way to develop web based access applications? b. Is there a good manual like "Pages for Idiots" which will...
6
by: Neil Ginsberg | last post by:
I have an Access 2000 mdb with a SQL Server 7 back end run on a WAN. The client is talking about converting it to a web-based application, after input he got some input suggesting that. (He has a...
16
by: sm_hall | last post by:
Hi, I manage and develop an Access 2003/SQL 2000 based system for a real estate company. It's quite extensive and has a level of Windows/Office integration. My question is this: what are the...
7
by: nugget | last post by:
Role-based security for an ASP/ASP.NET mixed environment Hello: My co-worker and I have been charged with designing role-based security for our intranet. The technologies we have to work with...
0
by: Yellowfin Reporting | last post by:
Announcing Yellowfin Version 2.5 upgrade release. (www.yellowfin.com.au) Existing SQLserver based users can take advantage of this upgrade as soon as convenient. Downloads are available through...
0
by: Yellowfin pty ltd | last post by:
Announcing Yellowfin Version 2.5 upgrade release. (www.yellowfin.com.au) Existing DB2 based users can take advantage of this upgrade as soon as convenient. Downloads are available through the...
6
by: Chuck Anderson | last post by:
I have decided to create a browser based Php application for a client/friend of mine (HTML forms to PDF, for one - perhaps a contacts interface). He has a web site, so I can upload the application...
0
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,...
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...
1
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...
0
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...
0
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...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
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 ...

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.