I have an MS Access frontend to a SQL Server 2000 database. The database was originally an Access mdb that I upsized using SQL Server's DTS wizard.
After setting the primary keys and identities for the original autonumber fields I began to test the interface to make sure it still worked.
I can insert and delete new records fine however any time I try to change an existing value I get a Write Conflict messagebox and the option to save the record is greyed out.
Clicking drop changes results in error '3197' which states you and another user tried to change the same data. However I am the only user. logged into this database (as it is being tested, not in production).
Anyone have any ideas as to what is causing this?
Does this thread belong here or a different forum?
After setting the primary keys and identities for the original autonumber fields I began to test the interface to make sure it still worked.
I can insert and delete new records fine however any time I try to change an existing value I get a Write Conflict messagebox and the option to save the record is greyed out.
Clicking drop changes results in error '3197' which states you and another user tried to change the same data. However I am the only user. logged into this database (as it is being tested, not in production).
Anyone have any ideas as to what is causing this?
Does this thread belong here or a different forum?