Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Can't edit linked SQL table

Posted on 2007-11-21
10
Medium Priority
?
1,314 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
[X]
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
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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 …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

688 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