[AccessD] Some Advice on Web Front end and ? backend

...you can use an Access be on a hosted web server with Asp.Net2 as your fe 
...if you are not comfortable with SQL Server but are with Access, that 
would be the way I'd go ...if you go with SQL Express, AccessD members Susan 
Harkins/Martin Reid wrote an Access to SQL Server book a while back that I 
used successfully to convert.

...despite all the Access disparagement you find on the web, my experience 
is that it is very serviceable, reliable, and fast for as many as 2000+ hits 
a day ...and probably more ..Drew claims higher numbers ...in more than a 
year of using an mdb as a web site be, I've not had a single problem with 
it.

...as for Asp.Net2 ...MS offers Visual Studio Web Developer Express 8 for 
free and there is terrific support ...I've not run into anything I need that 
it can't support as yet except compiling dlls ...and I really don't need 
that ...there are a LOT of free training videos that will walk you through 
the ide and get you familiar with the terminology and environment ...I've 
had little problem moving an Access fe to the web in that manner.

...in fact VSWDE has quickly become my preferred development environment 
...hth.

William

----- Original Message ----- 
From: "Darryl Collins" <Darryl.Collins at coles.com.au>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Sunday, March 30, 2008 6:14 AM
Subject: [AccessD] Some Advice on Web Front end and ? backend


>
> Hi folks,
>
> My partner runs a business and wants me to whip up a database for her 
> client data etc. (heh -dead easy right!).
>
> I originally put one together in Excel several years back which did the 
> job, but hey, it's Excel and now the business is growing it really need to 
> move to a better platform.  I did a rebuild in Access late last year to 
> see how it would all work, but I really am not sure Access is the way to 
> go given her requirements - I just didn't know any better at the time, and 
> I wanted to learn more about Access as well.
>
> Given she has 3 locations (clinic 1, clinic 2 and home) plus a numerous 
> staff who work in a similar way I was thinking that using her website 
> would be a good place to put the backend so it would easily accessable to 
> all authorised people.  I guess ideally she needs a server and WAN, but 
> that isn't going to be happening soon.
>
> I was thinking something like a secure area via her URL that the staff can 
> log into online and then access the forms, update the data etc would be 
> pretty darn handy for her.
>
> Would SQL Express (or similar) at the back (and housed on the server) and 
> maybe ASP.Net at the front for all the forms and GUI stuff be the 
> best/correct approach though?
>
> I did build her current website, but I used frontpage (urrrgh) & HTML and 
> it is all very 1994 in style and functionality!!  (that said, both her and 
> her clients like it as it is simple and easy to get around - go figure).
>
> My skills ASP.net and SQL Server almost zero at present - although the MS 
> site provides some great training resources which I have skimmed over. If 
> I take this path it is going to be a fun learning exercise I suspect.  I 
> have downloaded both ASP.net and SQL Express from MSoft, but haven't 
> really had time to play around too much (oh - did i mention I have a 6 
> month old kid??!! hmmm...).
>
> Anyway, If you guys and gals have any suggestions, war stories, gotachas 
> or general advice I would love to hear from you before I get too far down 
> any one path.  Definately open to ideas on this one.
>
> her current website is http://www.sprouttherapyservices.com.au/ for those 
> who want a trip back in style time! ;)
>
> Many thanks
>
> Darryl.
>
>
>
>
>
>
> This email and any attachments may contain privileged and confidential 
> information and are intended for the named addressee only. If you have 
> received this e-mail in error, please notify the sender and delete this 
> e-mail immediately. Any confidentiality, privilege or copyright is not 
> waived or lost because this e-mail has been sent to you in error. It is 
> your responsibility to check this e-mail and any attachments for viruses. 
> No warranty is made that this material is free from computer virus or any 
> other defect or error.  Any loss/damage incurred by using this material is 
> not the sender's responsibility.  The sender's entire liability will be 
> limited to resupplying the material.
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>