Looking for recomendation for Web Based front end

  • Thread starter Thread starter AkAlan via AccessMonster.com
  • Start date Start date
A

AkAlan via AccessMonster.com

I have just converted several mdb's to adp's and now would like to migrate to
a web based product like .ASP. Does anyone have any recommendations as to
which product would be the most practical. I have about 150 users on military
bases and it is a real pain every time I make a change to the front end and
have to push a copy out to the server and have them grab it. I will still use
SQL as the backend and the server resides on a machine with a web server
running. I will be more than happy to provide more info if it will help
determine which software to go with. Thanks for any help.
 
Any server side web technology + browser as front end will do: Java, PHP,
ASP, ASP.NET... It all depends what expertise you have or you ca find to do
it. Neverthe less, Access ADP is definitely not a cadidate of web app's
front end. Since you are asking in a MS tech. NG, on MS side, your option
would be .NET. Most likely, it is ASP.NET. If your app needs quite some
client side processing, you make consider Web Services+Smart client
technology from MS.

Be aware, going to web app, anything you have done in ADP (or mdb) would be
thrown away (only SQL Server server side objects, such as tables, views and
SPs could be re-used).
 
AvA> it is a real pain every time I make a change to the front end and have
AvA> to push a copy out to the server and have them grab it.

I think the drop of your productivity resulting from programming web pages
will far exceed that. Web programming is still much less efficient compared
to desktop.

Vadim Rapp
 
I disagree.

Are you talking about INTERNET or INTRANET??

You should run away from anything MS ever makes-- for web development.
From Interdev to Visual Studio to Visual Expression CRAP that they come
out with-- they just don't understand the market.

Buy a copy of Dreamweaver; the wizards ROCK.


-Aaron
 
AkAlan via AccessMonster.com said:
I have just converted several mdb's to adp's and now would like to migrate to
a web based product like .ASP. Does anyone have any recommendations as to
which product would be the most practical. I have about 150 users on military
bases and it is a real pain every time I make a change to the front end and
have to push a copy out to the server and have them grab it. I will still use
SQL as the backend and the server resides on a machine with a web server
running. I will be more than happy to provide more info if it will help
determine which software to go with. Thanks for any help.

If your concern is purely with distributing updates, then it would be
madness to redevelop your front end just to solve that trivial problem.
Simply automate the process. I always set up adp systems as follows:

"main" master copy of the adp file on a server
"local" master copy of the adp file on each workstation
"local" run copy of the adp file on each workstation (this is the one that
gets opened by the user).

What the users actually run when they launch the system is a vbscript which:

1. compares the last-modified timestamp on the main master and local
master
2. if they are different, copies the main master to replace the local
master
3. copies the local master to replace the run copy
4. launches the run copy.

This ensures that (i) every user gets a nice, clean adp every time they
launch the system (ii) updates to the adp get automatically distributed, all
you have to do is to update the main master and (iii) the file copy over the
network only occurs when it is really needed i.e. when the main master has
been updated.
 
Back
Top