What can I use for a data Input\output interface tool for SQL 2005 database?

Posted on 2009-02-19
Last Modified: 2012-05-06
I have an established database which I need the ability to access a record or records.

First, I want to just view the records.
Second, I want to be able to edit data in ther record.
       - Then I want to be able to save the edited data back to the database.

Is there some form based tool which has all the components necessary.  Or please provide recommendations on how I can resolve this issue. Thx.

Question by:rhservan
    LVL 57

    Expert Comment

    by:Raja Jegan R
    You can design a simple application either in VB or C# .Net to achieve that..
    LVL 51

    Expert Comment

    by:Mark Wills
    There is SQL Server Management Studio (SSMS) which will allow you to do that, or, if for "client" access then there are some other tools such as Toad, Then there is a web interface that can be downloaded, or, you can start a little bit of coding in  Visual Studio (and MS do have plenty of examples and tutorials), or Visual Studio Express, but then you are starting to create a form for the table in question.

    If you could give a bit more information as to the circumstances, then might be able to help out a bit more. If just for you, then use SSMS.


    Author Comment

    The database will need to be accessed by up to ten individuals & some with the ability to change or add data to the database fields per record.

    I am looking for explicit details for setting this up as an intermediate user.  

    Thanks guys for supporting my concern.

    LVL 51

    Accepted Solution

    OK, there are a few things....

    As a developer, or being able to create simple forms for data maintenance have a look at :

    for a step by step beginner guide :

    Here is a "starter" kit download :

    And a numer of them (scroll down to employee forms) :

    For more SQL Server type stuff (including reporting) look at :

    OR, as a user, maybe some of the code generators might be more appealing

    such as :


    and moving into the bigger versions :

    and wider reaching - more than just a gui front end :

    and for reporting / excel manipulations look at :  (going simple again)...


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now