SQL neewbie - looking for windows front-end app for SQL database backend

[terry433iid@yahoo.com]

Hi,
I'm new to SQL and databases in gnereal but am trying to source an
application for windows that will sit on top of a small SQL database I
have (created for local scout troup), I want an easy way to retrieve/
add/view data from backend in nice menu-driven GUI format (no cmd-
line).
Can anyone recommend a useful app I could source to do this
task....

thanks in advance
terry

[Madhivanan]

Re: SQL neewbie - looking for windows front-end app for SQL databasebackend

On Nov 14, 11:36 pm, "terry433...@ya hoo.com" <terry433...@ya hoo.com>
wrote:

Hi,
I'm new to SQL and databases in gnereal but am trying to source an
application for windows that will sit on top of a small SQL database I
have (created for local scout troup), I want an easy way to retrieve/
add/view data from backend in nice menu-driven GUI format (no cmd-
line).
Can anyone recommend a useful app I could source to do this
task....
>
thanks in advance
terry

VB6, VB.NET, etc

[jhofmeyr@googlemail.com]

Re: SQL neewbie - looking for windows front-end app for SQL databasebackend

On Nov 21, 12:42 pm, Madhivanan <madhivanan2... @gmail.comwrote :

On Nov 14, 11:36 pm, "terry433...@ya hoo.com" <terry433...@ya hoo.com>
wrote:
>

Hi,
I'm new to SQL and databases in gnereal but am trying to source an
application for windows that will sit on top of a small SQL database I
have (created for local scout troup), I want an easy way to retrieve/
add/view data from backend in nice menu-driven GUI format (no cmd-
line).
Can anyone recommend a useful app I could source to do this
task....

>

thanks in advance
terry

>
VB6, VB.NET, etc

Hi terry433iid,

Is the database you have a SQL Server database? If so, why not simply
use the default SQL Server ui (Enterprise Manager for 2000 and
Management Studio for 2005)?

I guess as an alternative you could use something like MS Access to
connect to the DB. This allows you to manage the tables directly, and
also makes it very easy to develop basic forms for managing your data
(I'm assuming that your db is pretty small, so performance is not
really an issue).

Good luck!
J

[Bart op de grote markt]

Re: SQL neewbie - looking for windows front-end app for SQL databasebackend

You can write php, java... :-), or make connection via ADO-DB in
office.

To easily add, delete, update rows in mySQL databases I use
InfoMaker. You can make reports too. The only thing you need is an
odbc connection to your database.

Regards,

Bart