 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / February 2008Unable to edit records
Hi, Exact problem : Suppose i had 1 to 10 records before linking the table in MS Access from Sql server 2005 After linking the table i have added records from 11 to 20 It allows me to edit the new added records from 11 to 20. I have not been able to edit the records from 1 to 10. why?? Please Help me. Thanks in advance. Naresh  SignaturePosted via a free Usenet account from http://www.teranews.com > Hi, > [quoted text clipped - 5 lines] > I have not been able to edit the records from 1 to 10. why?? > Please Help me. Please clarify "not been able to". Does the record simply not accept keystrokes? Do you get errors when attempting to save changes? If the latter, what are the specific error messages? Also, what are the fields and DataTypes of the fields and what is the Primary Key? SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Hi, Rick, When you edit the old records (before linking the table in MS Access from Sql server 2005) it shows write conflict error. datatypes are text, number, bit. exact problem : suppose you have 5 records in a table name employee (in sql server 2005). After linking this employee table from sql server to MS access you have added 5 more new records. so, now total records are 10 (5 old records + 5 new records). when you edit the old records it does not save the changes. Hope this will clear your confusion. If not then please create one table in sql server2005 and 5 records. Then link that table to Ms- Access 97. After linking the table, open the table using MS Access and edit the recors. It wont saves the changes. Thanks Naresh >> Hi, >> [quoted text clipped - 13 lines] > Also, what are the fields and DataTypes of the fields and what is the > Primary Key? SignaturePosted via a free Usenet account from http://www.teranews.com > Hi, Rick, > [quoted text clipped - 13 lines] > After linking the table, open the table using MS Access and edit the > recors. It wont saves the changes. Sorry, but I have hundreds of SQL Server linked tables to Access 97 as well as linked tables form other server databases and they all update just fine. Do your bit fields allow Nulls? Access does not like that. Change them to not allow Nulls or change the type to Integer. Also try adding a Timestamp field to the table on the server. That solves many ODBC update problems. You didn't say what kind of "number" field you have and which fields are in the Primary Key. If you have a field that does not map exactly to a type in Access in your Primary Key that can also cause update problems. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.