As you know, Ive been developing a database for the past 9 or 10
months(seems longer!!!) I am getting quite close to finishing the
development phase of the project ( I think) And I have to start thinking
about deployment. I have been watching with interest all the threads about
security and deployment, making EXE's etc. Someone I talked to the other day
mentioned ASP and deploying the database to our intranet. What are people's
thoughts on ASP as a deployment method. What are some of the
advantages/disadvantages of using ASP to deploy an Access Database. Finally,
can anyone recommend any good resources (Books, online, etc.) that I should
look at to learn ASP?
TIA
Colin
> Someone I
> talked to the other day mentioned ASP and deploying the database to
> our intranet. What are people's thoughts on ASP as a deployment
> method. What are some of the advantages/disadvantages of using ASP to
> deploy an Access Database. Finally, can anyone recommend any good
> resources (Books, online, etc.) that I should look at to learn ASP?
Wrox Publishing makes a set of VERY good ASP books (http://www.wrox.com).
http://www.4guysfromrolla.com is a good ASP site.
ASP allows anyone with a web browser to access the data. ASP is my
preferred choice for deployment since it's lightweight and very simple to
develop.
You may want to look into ColdFusion, PHP (free), JSP (semi-free),
ASP.NET (semi-free), etc as well. These languages provide similar
capabilities to ASP. ColdFusion, JSP, and ASP.NET are substantially more
powerful than ASP - if such flexibility is required.
Is your company looking for an ASP programmer? I know several people who
can do it for you for a low price (including myself!). We're mostly
students looking for a summer job (in Toronto too!).
--
Lucas Tam (REMOV...@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/ <- Cheap Stuff!
> Hi Guys and Gals.
ASP:
Advantages
1. HTML forms have greater UI capabilities than Access forms;
2. ASP applications are unbound; typically connections last for less than
one second; thus concurrency problems are minimized; 3. ASP runs on the
server; thus, client installations are irrelevant, except for a browser
installation for which, perhaps, you may specify requirements; I'd
recommend IE 6.
Disadvantages
1. HTML forms are not so RAD like;
2. There is, perhaps a greater potential for security breaches;
3. If you're not a "programmer", the learning curve will be steep.
Books:
1. ASP itself is a very tiny technology. You can probably learn enough
about ASP just from its help file; 2. BUT, you need to learn a database
connection technology, probably ADO, HTML, DHTML, CSS, a client scripting
language, probably Javascript, and a within ASP scripting language; I
recommend JScript for the latter but VBS, which is very much like VBA is
probably the standard for converted Access Developers. 3. I find Wrox
books virtually worthless as they seem to try to turn each technology into
a sing-song novel; I much prefer the O'Reilly Books with their gutsy
no-nonsense no-flab approach.
The most serious problem with an ASP application is that of reports. You
may have to purchase and learn Crystal Reports if your reporting needs are
anything greater than a print out of an html page.
--
Lyle