Run stored proc using 'sa' login causes write conflict
Posted on 2002-06-26
I have a SQL Server 2000 db connected to an Access Project (.adp) front-end.
My front-end has forms with buttons that users click on to perform calculations and update data on the form. The code behind the buttons are in VB and execute stored procedures that update fields.
I make the connection in the VB code using:
myCmd.ActiveConnection = "Provider = SQLOLEDB; Data Source = server; Initial Catalog = database; User ID = sa; Password=;"
The problem I get is that everytime a user runs the code and the record is updated, the user gets the message:
Write Conflict: The record has been changed by another user since you started editing it...
Each user has their own UserName, so that is why I get the message because it has been updated by 'sa'.
How do I get around this? I don't want to connect as the user as their passwords may change, etc.