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

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

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

On Nov 14, 11:36 pm, "terry433...@yahoo.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

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

On Nov 21, 12:42 pm, Madhivanan wrote:
> On Nov 14, 11:36 pm, "terry433...@yahoo.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

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

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