[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.