Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Can't edit linked SQL table

Posted on 2007-11-21
10
Medium Priority
?
1,315 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 66

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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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
 

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 66

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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

916 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