Solved

Editing data easier with SQL Server 2005

Posted on 2007-12-03
7
152 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
  • 4
  • 2
7 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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.

911 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