Another Need Help for Choosing an SQL Server front end

Hi,
I'm just in the planning stages of upgrading a small bunch of databases
to MS SQL Server (2003). The current databases are very poorly
designed, so I'm basically starting from scratch. The databases will
grow to be quite large over time, and we have plenty of space for it.
Currently the number of users is about 15 in total. I would prefer to
web-enable it using our intranet since I have skills in programming JSP,
html, etc. But don't have time to learn ASP or ASP.Net. Am also
proficient with MS Access but have found it a little unstable in the
past.
Is there anything someone could recommend as a front-end?
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
"AMH" <anonymous@.blah.com> wrote in message
news:ukIxMAgHFHA.3244@.TK2MSFTNGP09.phx.gbl...
> I'm just in the planning stages of upgrading a small bunch of databases
> to MS SQL Server (2003). The current databases are very poorly
> designed, so I'm basically starting from scratch. The databases will
> grow to be quite large over time, and we have plenty of space for it.
> Currently the number of users is about 15 in total. I would prefer to
> web-enable it using our intranet since I have skills in programming JSP,
> html, etc. But don't have time to learn ASP or ASP.Net. Am also
> proficient with MS Access but have found it a little unstable in the
> past.
> Is there anything someone could recommend as a front-end?
There is no SQL Server 2003... 2000 is the current version. Microsoft Access
still makes a reasonably good front end. If the data is constantly being
changed by your users, you will need to learn to be proficient in multi-user
VBA coding techniques.
Steve
|||I can't see the users changing data so much. There'll be a lot of data
entry, and a lot of querying to find trends, patterns, etc.
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||When you buy sql server 2000 it comes already with a good GUI front end
called Enterprise Manager. It is very easy to use and you could control
who has access to what.
It is free too and can be installed on everybodies workstation.
|||But Enterprise Manager isn't designed to be a front end tool
for end users. It's a "quick and dirty" administration tool.
It's not necessarily free to distribute to everyone. It's
still governed by licensing.
-Sue
On 1 Mar 2005 16:41:48 -0800, thomasamillergoogle@.yahoo.com
wrote:

>When you buy sql server 2000 it comes already with a good GUI front end
>called Enterprise Manager. It is very easy to use and you could control
>who has access to what.
>It is free too and can be installed on everybodies workstation.
|||Thanks, but Enterprise Manager is more for the administrative side of
things - that's what I'll use. But I'm after a user interface that I
can build for the every-day user who can't have direct access to the raw
data.
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||"AMH" <anonymous@.blah.com> wrote in message
news:uYxTSzsHFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Thanks, but Enterprise Manager is more for the administrative side of
> things - that's what I'll use. But I'm after a user interface that I
> can build for the every-day user who can't have direct access to the raw
> data.
One solution, use Microsoft Access as your front and create custom views in
SQL Server. The users never sniff the raw data tables
Steve