Hi,
I wrote an Excel Macro in VBA which imports records into a SQL server database & an access database.
The import went fine, however the users cannot edit or delete any of the rows imported because of a Write conflict error message.
I have asked the users to restart their SQL server and the Access clients but it has had no effect. Is there any way of clearing the record locks?
Cheers
Dee
I wrote an Excel Macro in VBA which imports records into a SQL server database & an access database.
The import went fine, however the users cannot edit or delete any of the rows imported because of a Write conflict error message.
I have asked the users to restart their SQL server and the Access clients but it has had no effect. Is there any way of clearing the record locks?
Cheers
Dee