Solved

Can't edit linked SQL table

Posted on 2007-11-21
10
1,303 Views
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!
Thanks!
0
Comment
Question by:BobRosas
10 Comments
 
LVL 16

Expert Comment

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

Author Comment

by:BobRosas
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.
0
 
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.

0
 

Author Comment

by:BobRosas
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!
Thanks!
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:BobRosas
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.
Thanks
0
 

Accepted Solution

by:
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!
 
0
 
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.
0
 

Author Comment

by:BobRosas
ID: 20330378
Hopefully I posted it correctly.
Thanks again for all your help!
0
 
LVL 1

Expert Comment

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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

746 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

11 Experts available now in Live!

Get 1:1 Help Now