?
Solved

Editing data easier with SQL Server 2005

Posted on 2007-12-03
7
Medium Priority
?
158 Views
Last Modified: 2010-08-05
I am new to SQL Server 2005 (and SQL in general)
I mainly used MS Access databases in the past.  
Using Access to edit, look at and sort data is extremely easy.

With SQL Server, I find it almost impossible.  
The only tool I have right now is SQL Server Management Studio

I can't seem to sort properly, on any fields (if at all), I cannot easily edit one field.
There are many jobs I used to do with Access that are no longer practical in SQL Server.
With SQL server, I have to write code to do the easy stuff.

So my question is:

Is there a third party interface to SQL server data that makes it as easy to massage the data?
Something that will alow me to edit column by column or field by field, searchable sortable and as "friendly" as Access?


I am really looking for people who know what I am talking about and have a program they use (or used) in mind. I am not looking for  just a general link to a third party app (I can get that on google), so if you haven't at least tried it, please don't respond.



0
Comment
Question by:EGormly
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 20395739
If you are very comfortable in Access, you can just Access as the front-end to the SQL 2005
database.

1) Create a new Access MDB file

2) Go to File|Get external data|Link tables to launch the table-linking wizard

Once you link in the SQL 2005 tables, you can view/edit/query/report on them as if they were
Access tables.
0
 

Author Comment

by:EGormly
ID: 20395807
Hey that's really cool...

ony one problem, nothing is editable, did I miss a setting somewhere?
Its just like in SQL Server, I cannot edit anything (at least I can sort)

I need to be able to edit, editing is more important that sorting.
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 20395875
If you're looking for buttons to sort columns or search columns you are right you won't find that.  However, you shouldn't have any trouble easily editing any field if you just open a table.  

SQL Server Management Studio really isn't the best place to be editing your data anyway.  You should be doing it through queries which will allow you to use transactions.  Transactions can save your behind if you do the wrong thing.

While MSAccess is "friendly" it's also costly.  When you query data or open tables in MSAccess you are almost always sending your entire database across your network, unless you're using pass-through queries.  
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:EGormly
ID: 20395965
cmangus:
Take no offense, I do truly appreciate your efforts to answer.

That said:

You said
>>"If you're looking for buttons to sort columns or search columns you are right you won't find that."

I thought I made that clear, I want to use data like I did before with Access.
So clearly, using SSMS is not what I want.

>>"However, you shouldn't have any trouble easily editing any field if you just open a table. "
I have lots of trouble as I stated in the opening question, I cannot edit the data, I do not know why and thus.. one of the reasons for this post.

>>"You should be doing it through queries which will allow you to use transactions."

When I have an order in my system and I need to change the Purchase Order number from 12456A to 12345B,  using a queries which allows me to use a transaction is a completely ridiculous method (to me at least).

Not only wouldn't I know where to begin with querries and transactions, but my entire goal was to be able to edit like I used to in Access, (a 5 second change in that example)


I just need an easier way to manipulate my data, I have limited time and it is usually devoted to other areas.
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 20396317
I understand where you're coming from.

If you can't edit data directly in tables in SSMS then you don't have the necessary permissions.  This problem was also reflected in your inability to edit data in linked tables via MSAccess.  You need to check with your DBA and have your permissions corrected.

While you may find queries a ridiculous way to maintain data, it is the safest and best way to do it.  In the long run, you'll find it serves you well to learn how to to it.  It's quite simple.  I do recognize that this doesn't solve your immediate problem.

Once your permissions are fixed, you should be able to work with the data in MSAccess.  No third party tool is required.
0
 

Author Comment

by:EGormly
ID: 20396855
Thank you cmangus
I am giving the points to matthewspatrick for hthe first reponse with Access links
(I am a dolt for not realizing that)

but you have helped as well, I will look into queries at a later time.

0
 

Author Closing Comment

by:EGormly
ID: 31412323
pretty silly that I didn't already know this or even try it.
Thanks!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

770 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