Modify data in SQL Server with access mdb

hello

I'm trying to use access to modify data in SQL Server 2000 tables. Everything is ok on most tables, but only one made me troubles. This one when I'm doing something on it is saying that an other user modify this record and I cannot save this information.

This table has 40 rows and 3 primary key.

I'm the only one to work on this database.

thank you for responseDoes your table have any bit data types which allow null values? Access can't deal with null value data bit columns and if you modify a row with a null value it gives you an error saying it has already been modified by another user.

hope this helps

Originally posted by anakin_ch
hello

I'm trying to use access to modify data in SQL Server 2000 tables. Everything is ok on most tables, but only one made me troubles. This one when I'm doing something on it is saying that an other user modify this record and I cannot save this information.

This table has 40 rows and 3 primary key.

I'm the only one to work on this database.

thank you for response