Unable to edit records

  • Thread starter Thread starter naresh
  • Start date Start date
N

naresh

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
 
naresh said:
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.
Click to expand...

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?
 
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
 
naresh said:
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.
Click to expand...

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.
 
Back
Top