Write Conflict Access 2000 with SQL 7

Write Conflict Access 2000 with SQL 7

Post by Curtis » Fri, 21 Mar 2003 05:34:35



I am having problems on a subform using Access 2000 with SQL Server 7.
First I changed all of the bit fields to a default of 0. That did no
good. Then I changed them to INT data type. I am still geeting write
conflict messages and have to end the ADP project through task manager.
Any ideas?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 
 
 

Write Conflict Access 2000 with SQL 7

Post by Mary Chipma » Sun, 23 Mar 2003 06:06:15


Your best bet is to put a Profiler trace on the app to see exactly
what's being sent from Access to cause the error. It's not clear from
your message what's going on. Sometimes adding a timestamp column to
the table  helps.

-- Mary
MCW Technologies
http://www.mcwtech.com



Quote:

>I am having problems on a subform using Access 2000 with SQL Server 7.
>First I changed all of the bit fields to a default of 0. That did no
>good. Then I changed them to INT data type. I am still geeting write
>conflict messages and have to end the ADP project through task manager.
>Any ideas?

>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!