[AccessD] Win2K, Access 2002 SP2

John,

Please keep us posted as we're comtemplating the move to A2K2 in the near future (already at Win2K).

Thanks,

Jim DeMarco
Director Product Development
Hudson Health Plan


-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com]
Sent: Thursday, October 23, 2003 1:36 PM
To: AccessD
Subject: [AccessD] Win2K, Access 2002 SP2


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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************