Access 2000 Upgrade-Write Conflict Error

[soloprogrammer]

I just recently converted an Access 97 application to Access 2000 with a SQL server backend database.

Here’s the issue: The users are getting the following error: “Write Conflict—The record has been changed by another user since you started editing it. If you save the record, you will overwrite the other user made”-- with the buttons Save Record (which is grayed out and unavailable), Copy to Clipboard or Drop Changes. They get this error when they try to update certain fields in the record. I notice if they create a new manifest (new record) and copy the data from an existing manifest, they DO NOT get the error for these fields. But if they create a new manifest (new record) with user input data, they do get the Write Conflict error.

I set up a test database in SQL Server and I get the same error. I know I am the ONLY user in the application. So the write conflict error just doesn’t make sense to me.

The datatypes for these fields with the problem are defined in Access as TEXT and in SQL Server as VARCHAR.

Also the application was originally written in DAO.

Any suggestions would be great!

Thanks in Advance

 

[Rolliee]

sounds like multiple instances. Do you have any other mdb's pointing to this recordset - concurrently?

Rollie E