Write conflict Error message

A

access

Hi,

I am getting the write conflict error message some times but not always.

Its ADP project and back end is sql server 2005 express edition. when ever I
try to enter new record using forms i get this error some times.
I did put timestamp clolumn on the table ,bit field is having default value
as 0 and it is not null feild still i am getting write conflict error message.
 
S

Sylvain Lafontaine

Not enough information here. You should tell us more about the design of
the tables/application.

Any chance that you might have some VBA code changing the data behind the
form/subform? Are you sure that there is a primary key for this table?
Maybe you have two foreign keys (2 fields) pointing to the same table? Any
strange type of field like Decimal (32,2)?

Take a look with the SQL-Server Profiler, this will tell you what Access is
trying to do and will probably put some light on this problem.
 
Top