[AccessD] Win2K, Access 2002 SP2

John Colby jcolby at colbyconsulting.com
Thu Oct 23 12:36:22 CDT 2003


I just wanted to give a heads up - I have a client that is using Office
2002.  He is getting the JET error "the operation was halted because you and
another user...".  This error only occurs on machines that have SP2 applied
(2 out of 5) whereas those with SP1 (3 of 5) don't get the error.  The error
occurs as the data is being saved into the table, after AfterUpdate.  Oddly
enough the data did go in to the table.

Nothing obvious, compacted / repaired the BE and FE using the built-in
compact etc.  The standalone compact/repair program failed early on
(immediately).

I do not know for sure that it is a SP issue, however those that had SP1
worked, those with SP2 failed.  Since I only have 5 machines it isn't a done
deal that this is the issue.  On the other hand I was loath to break a
functioning machine by applying the SP2 to one of those that worked to see
if it broke.

I did try uninstalling, then reinstalling and applying only SP1.  The
machine still failed.  Likewise not conclusive evidence since uninstall
leaves trash behind.

John W. Colby
www.colbyconsulting.com




More information about the AccessD mailing list