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 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
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
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
"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
"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 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.
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
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
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
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> 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
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 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
"(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
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
"(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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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
|
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
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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"....
|
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...
|
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...
|
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 =...
|
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...
|
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...
|
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...
|
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...
|
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)...
| |