Can't edit linked SQL table

Posted on 2007-11-21
Last Modified: 2013-11-28
I have a new database with about 20 SQL tables.  I linked them to Access 2007 and I can open all the table and change the data except for 1.  The one table I can't edit is my main table and is linked to 12 of the other tables.  Is there a limit?  I was able to add a record but as soon as I left the record and tried to edit it I get the error Write Conflict...Save (greyed out) Copy to Clipboard or Drop Changes.  Why just this one?  I've tried deleting the link and relinking with no luck.
Please help!
Question by:BobRosas
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
LVL 16

Expert Comment

ID: 20329292
could have something with integrity that could have been set up

Author Comment

ID: 20329331
I forgot to mention that if I open SQL Server 2005 I can edit the table there.  That's why I thought it was linking but I've deleted and re linked with no success.  If it were an integrity thing would it still work in SQL Server?  I really don't know!  I'm stumped!
Thanks for your quick response.
LVL 65

Expert Comment

by:Jim Horn
ID: 20329398
{wild guess}
In SQL, double-click on the table, then click on the Permissions button, and see what the UPDATE-INSERT-DELETE permissions look like for the user you are linking with.

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 20329570
That sounds logical, if only I could find the permissions data.  I'm in SQL Server 2005, I've tried looking in properties.  I've tried the help button.  I'm sure it's obvious, just not to me.  Any additional help would be great!

Author Comment

ID: 20329814
I found the permissions tab (it was obious) but ther are no extra permisions and I'm setup with Admin permissions so I still can't find the problem.  I plan to unlink everything and relink next.  I'm running out of things to try.  But I'm still open to suggestions.

Accepted Solution

BobRosas earned 0 total points
ID: 20330285
I found it.  I had a field data type as Bit with null checked.  As soon as I unchecked it all was well again.

Now I don't know how to award points since I figured it out.  I thought there use to be a FAQ page and I can't find that either.

Thanks for all your help!
LVL 65

Expert Comment

by:Jim Horn
ID: 20330320
>Now I don't know how to award points since I figured it out.
Good job.  Post in Community Support and request a PAQ-Refund of this question.
Make sure you give them the url.

Author Comment

ID: 20330378
Hopefully I posted it correctly.
Thanks again for all your help!

Expert Comment

ID: 20345559
Closed, 250 points refunded.
Community Support Moderator

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

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.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

730 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