473,287 Members | 1,655 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,287 software developers and data experts.

Browser-based or Access front end?

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 pros and cons of ditching Access in
favour of a web based front end?

Thanks,

Simon Lane
Nov 13 '05 #1
16 3719
sm*****@hotmail.com wrote:
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 pros and cons of ditching Access in
favour of a web based front end?

Thanks,

Simon Lane


If your users need to be able to use it outside your company LAN then a
web-based front end is useful. If not, you are expending a LOT of work to
basically design the front end all over again for a finished product that
your users will not like as much. Plus your Windows/Office integration will
for the most part be gone.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2
On 11 Jan 2005 04:27:49 -0800, sm*****@hotmail.com wrote:

What pros and cons have you come up with so far?
Why are you considering making this move?

-Tom.

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 pros and cons of ditching Access in
favour of a web based front end?

Thanks,

Simon Lane


Nov 13 '05 #3
You will find that a browser based front end is able to query your data much
faster
as the server does not have the overhead of Microsoft Office. Also, you can
access
your data from anywhere. You also have more control over the output of your
data,
if you know how to write ASP/HTML.

Cons, lots of work, security, learning curve is steep.

<sm*****@hotmail.com> wrote in message
news:20**************************@posting.google.c om...
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 pros and cons of ditching Access in
favour of a web based front end?

Thanks,

Simon Lane

Nov 13 '05 #4
"Rick Brandt" <ri*********@hotmail.com> wrote in
news:34*************@individual.net:
sm*****@hotmail.com wrote:
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 pros and cons of ditching
Access in favour of a web based front end?


If your users need to be able to use it outside your company LAN
then a web-based front end is useful. If not, you are expending a
LOT of work to basically design the front end all over again for a
finished product that your users will not like as much. Plus your
Windows/Office integration will for the most part be gone.


Let me second for emphasis this latter point: with Office
integration, it's not going to work very well as a browser-based app
unless you know how to do some pretty fancy things with COM.

And, of course, you can provide access to people outside your
company via Windows Terminal Server, without needing to re-engineer
your application.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #5
"miTch" <mi******@nospam.topsideinc.com> wrote in
news:1105456607.9581c70732bbf24f109126fd64168ad0@t eranews:
You will find that a browser based front end is able to query your
data much faster
as the server does not have the overhead of Microsoft Office.


Absolute rubbish.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #6
sm*****@hotmail.com wrote in
news:20**************************@posting.google.c om:
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 pros and cons of ditching Access in
favour of a web based front end?


A well designed web based front end may work without error on more machines
than an equally well designed Access front end, and it may have a wider
potential scope for implementaion.
HTML forms can have be more responsive and "programmable" than Access forms.
One always has the latest version of a web based application.
****
Developing a web-based front end may require more time and expertise than
developing an Access front end.
The quality and ease of creation of Access Reports may be difficult to match
with a web-based front end. (This is the most concrete of the pros and cons,
in my opinion.)
Access applications may be more secure than web based front ends.
****
After a dozen years or so using Access intensively I have abandoned it except
for simple utilities and very preliminary prototyping.

--
Lyle
--
use iso date format: yyyy-mm-dd
http://www.w3.org/QA/Tips/iso-date
--
The e-mail address isn't, but you could use it to find one.
Nov 13 '05 #7
Hi Tom,

We are exploring the idea of doing some web-based development, the
sense being that it's almost a must. I favour enhancing our current
Access/SQL work with ASP or the like that can be accessed from home or
at clients.

One option would be to gradually replace the Access front end, but
there clearly has to be a good set of reasons to do this.

There is also the sense that net technology is somehow the future.
Simon

Nov 13 '05 #8
Per sm*****@hotmail.com:
My question is this: what are the pros and cons of ditching Access in
favour of a web based front end?


I've had two MS Access applications replaced by web-centric systems by the IT
department of one of my clients.

The first one, delivered by me for less than $55,000 wound up costing something
in excess of 3 million....and it was largly a straight-up port.

The second one, delivered over a period of five years for something under
$225,000 was more than just a port: significant extra functionality was
added...let's say 30%. Last time I checked, they'd spent *over* 22 mil on the
thing and release one hadn't been put out there yet.

Bottom line for me: net-centric development takes a *lot* more manhours.

--
PeteCresswell
Nov 13 '05 #9
On 11 Jan 2005 16:28:11 -0800, sm*****@hotmail.com wrote:

Perhaps you could consider a hybrid: use the Access version in-house,
and develop a few web pages for outside clients.
If you're new to web development: make sure you can walk before you
try to run.

For new development, one would not use ASP, but ASP.NET.

-Tom.

Hi Tom,

We are exploring the idea of doing some web-based development, the
sense being that it's almost a must. I favour enhancing our current
Access/SQL work with ASP or the like that can be accessed from home or
at clients.

One option would be to gradually replace the Access front end, but
there clearly has to be a good set of reasons to do this.

There is also the sense that net technology is somehow the future.
Simon


Nov 13 '05 #10
On Tue, 11 Jan 2005 23:55:58 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote:

Your "unless" seems unwarranted. Review
http://support.microsoft.com/default...b;en-us;257757 and you
would have to conclude Office on the server is a no-no.

-Tom.
<clip>
Let me second for emphasis this latter point: with Office
integration, it's not going to work very well as a browser-based app
unless you know how to do some pretty fancy things with COM.

<clip>
Nov 13 '05 #11
sm*****@hotmail.com wrote:
Hi Tom,

We are exploring the idea of doing some web-based development, the
sense being that it's almost a must. I favour enhancing our current
Access/SQL work with ASP or the like that can be accessed from home or
at clients.

One option would be to gradually replace the Access front end, but
there clearly has to be a good set of reasons to do this.

There is also the sense that net technology is somehow the future.
Simon


You seem to be getting "swept along with the current" in your decision
making here. A change in the technologies you use should be done to address
a business need that is REAL. Not because "it's the future (we think)" or
because "everyone elses appears to be going that way".

If you do this you risk spending a lot of time and money and if that effort
does not deliver something that is tangibly better *for the user* at some
point you will be asked to justify why you made the change. Do you really
want to answer with either of the two reasons stated above?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #12
Tom van Stiphout <no*************@cox.net> wrote in
news:7n********************************@4ax.com:
On Tue, 11 Jan 2005 23:55:58 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote: <clip>
Let me second for emphasis this latter point: with Office
integration, it's not going to work very well as a browser-based
app unless you know how to do some pretty fancy things with COM.

<clip>

Your "unless" seems unwarranted. Review
http://support.microsoft.com/default...b;en-us;257757 and
you would have to conclude Office on the server is a no-no.


I'm not talking server-side. I'm talking about COM on the
client-side, initiated from the browser. It's likely impossible with
any browser other than IE, but I've read about it. It's brutally
difficult and subject to failure.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #13
sm*****@hotmail.com wrote in
news:11*********************@c13g2000cwb.googlegro ups.com:
We are exploring the idea of doing some web-based development, the
sense being that it's almost a must. I favour enhancing our
current Access/SQL work with ASP or the like that can be accessed
from home or at clients.
If what you need is access to the application from offsite, Windows
Terminal Server is the no-brainer method for supplying this
capability.
One option would be to gradually replace the Access front end, but
there clearly has to be a good set of reasons to do this.

There is also the sense that net technology is somehow the future.


Rubbish.

If there is no business need for a web-based application, then don't
spend money on building it.

Most people who think they need to web-enable their apps are really
confusing "we need to give remote access to the app" with "we need
to make the app available through the web browser." The latter is
*one* method of doing so, but the former is a broader goal that can
be implemented a number of ways.

In other words, you've chosen a single implementation solution
before having defined the problem you're trying to solve.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #14
"(Pete Cresswell)" <x@y.z> wrote in
news:8c********************************@4ax.com:
Per sm*****@hotmail.com:
My question is this: what are the pros and cons of ditching Access
in favour of a web based front end?
I've had two MS Access applications replaced by web-centric
systems by the IT department of one of my clients.


I've had this happen to me once.
The first one, delivered by me for less than $55,000 wound up
costing something in excess of 3 million....and it was largly a
straight-up port.


In my case it was c. $50K vs. c. $150K.

The replacement app, by the admission of its own developers, had
less than half the functionality of my app.

This was a pointy-haired-boss solution, implemented when management
changed (the partner who never liked me ended up in control of the
firm).

That firm ceased business operations 2 years ago.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #15
Per David W. Fenton:
That firm ceased business operations 2 years ago.


I guess it's a character flaw, but I've always derived a certain amount of
perverse satisfaction from seeing outfits go under after I've told them about
something they're doing wrong and they've ignored it.

Not that what they were doing wrong probably had that much to do with their
demise...but still...
--
PeteCresswell
Nov 13 '05 #16
"(Pete Cresswell)" <x@y.z> wrote in
news:jj********************************@4ax.com:
Per David W. Fenton:
That firm ceased business operations 2 years ago.


I guess it's a character flaw, but I've always derived a certain
amount of perverse satisfaction from seeing outfits go under after
I've told them about something they're doing wrong and they've
ignored it.

Not that what they were doing wrong probably had that much to do
with their demise...but still...


Well, this firm was a bunch of people that I really, really liked. I
sub-leased an office from them, managed their network, did all sorts
of things for them.

But the boss lost interest in her company about 4 years into it, and
the whole thing basically collapsed at that point.

I learned a very important lesson: businesses based on personality
don't scale. In fact, they don't even survive once the inspiriring
personality departs.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #17

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

Similar topics

7
by: Szar | last post by:
JS noob. I've seen plenty of browser detection scripts but they all seem to be slightly different and don't really fit my needs. I have various places where if the browser is IE I'd like to display...
6
by: hb | last post by:
Hi, Would you please tell me how to detect if the client's browser is closed? I need such event to trigger a database modification. Thank you hb
2
by: Craig G | last post by:
is there a way to distinguish whether a client is using IE or Netscape? is there some sorta check i can run on the Page_Load event? or where would be the best place to do this? Cheers, Craig
1
by: Dave Harrington | last post by:
Greetings all - We have a client who uses Lotus Notes as their default e-mail. The version of Lotus they use can run internet explorer windows within Lotus. I'd like to find if they are...
4
by: Peter Larsen | last post by:
Hi, I want to be able to show a file browser embedded on a form - a browser which is similar to the browser you get by SHBrowseForFolder(). Is that possible ? Thank you in advance. BR Peter...
15
by: CMM | last post by:
So I'm half way through overseeing a large project in ASP.NET 2.0. My superiors have decided that it would be nice if we ensured the site worked on all the major platforms (as they see it: IE,...
0
by: toeffetommy | last post by:
Hello, I need a piece of functionality developed for our Website and I need some technical advice on how get there. Essentially, what I want to develop is a browser-within-browser...
5
by: Mufasa | last post by:
We want to keep track of what OS/Browser people are using for our website. How can I find that out so that I can write it to a DB ? I know how to get it into the DB; I just need to know how to get...
0
by: etnaelk | last post by:
Hi all, I have a real bugger of a problem that I just haven't been able to figure out. I am working on writing my own proxy server in C# using TcpListener, TcpClient, HttpWebRequest/Response and...
10
by: Conrad Lender | last post by:
In a recent thread in this group, I said that in some cases object detection and feature tests weren't sufficient in the development of cross-browser applications, and that there were situations...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.