Hi all,

I have a requirement to build a web-based front end for a SQL Server
back end for users to view data, input data, produce documentation,
etc.

I currently use a MS Access database (non-web-based), but need to
expand to allow access over the internet.

Can anyone suggest a product that sounds appropriate?

I've considered ASP.Net, Cold Fusion, Front Page(?), ADO.Net(?), but
I'm don't know too much about them. Any advice is appreciated.

Many thanks,

Chris, you can use MS Access or SQL Server, your choice should depend
on if you need all the power of SQL Server and are willing to pay or if
you can use Access. How many concurrent users do you have? Because web
based programs use far less resources on a databases you will probably
be fine with Access. In any case you should start with Access and ASP
and go from there.

If you need me I can do this project for you, you can see me and some
of my work and also get my resume from my web server, the URL is
www.BobSweeney.Com/

Best regards,

Bob Sweeney

Hi

[quoted text, click to view]

[ SNIP ]

[quoted text, click to view]

Why don't you use an already made web-based front end ? There are a lot...
Have a look to myLittleAdmin here http://www.mylittletools.net/mla_sql
Live demo: http://www.mylittletools.net/livedemo/mla_sql

Best regards

On 18 Mar 2005 09:22:39 -0800, chrissmith_76@yahoo.co.uk (Chris)
[quoted text, click to view]

ASP.net is nice for developing web front ends if you don't mind coding
I use c# and the System.Data.SqlClient Library but you can use any
language supported by the .net setup
http://www.codeproject.com/ has some really nice articles.
All you need is a secured :-) IIS 6 webserver, a secure database,
choose your preference and start playing.
A good point is you can also develop for an access database then very
easily port to a ms sql server
You can use Visual Studio to develop or a plain text editor will do
the job.