Solved

Can't edit linked SQL table

Posted on 2007-11-21
10
1,306 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
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 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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 Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

777 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