Access form locks-up during load 1 time out of 10

From: Chunda (nospamxx_paul.higgs_at_designvillage.gg_xxnospam)
Date: 10/18/04


Date: Mon, 18 Oct 2004 12:51:20 +0100

Hi,

I've got a database running at a clients that is an Access 2000 SP-1 ADP,
connected to SQL 2000 SP3. Access is on Windows 98 SE client machines, SQL
on a Windows 2003 SBS Enterprise.

On one of the forms used for product management will load 9/10 times ok -
only 1125 records. However, one time it will load and in the record counter
at the bottom stop at say 100. At this point access locks and needs to be
terminated in task manager, or the PC rebooted.

Any ideas what might cause this? I've even tried turning off the Sohos virus
checker on the ADP. If the same form is opened with a filter specified so
only one record is shown they never see a problem. It occurs on a number of
workstations.

I haven't tried an updated to SP3, as the fixes documented for this don't
seem to have a solution to this problem - and I didn't what to cause any
others.

Does anyone have any ideas what could be the cause of this issue?

Thanks
Paul



Relevant Pages

  • Re: Help! SQL Errors after Win 2000 to Win 2003 Upgrade
    ... I'd therefore try reinstalling the service packs up to SP3 ... Win 2003 both of our SQL Server applications are behaving very badly. ... reinstall of Windows 2003, SQL 2000, and all of the applications? ...
    (microsoft.public.windows.server.general)
  • Migrate Operating System to Windows 2003
    ... I have Windows 2000(SP3) with Sql 2000. ... paralel enviroment. ...
    (microsoft.public.sqlserver.setup)
  • Re: SP3
    ... If your copy of Windows is legit and genuine, ... Windows XP Service Pack 3 Preview actually contains security updates and ... do with the final release of Windows XP SP3 other than the random comments ... computer and get the newest hardware driver and install it. ...
    (microsoft.public.windowsupdate)
  • Re: Windows UpDate: XP Service Pack 3 / Access Denied / Error 0x80
    ... response when attempting to DownLoad and Install Windows XP Service ... Error message when you try to install Windows XP Service Pack 3: ... WinXP SP3 - Read all prerequisites for a successful installation ...
    (microsoft.public.windowsupdate)
  • Re: Updates
    ... I had all the updates, but then picked up some virus and ended up ... I still know people running Windows 98 happily. ... I have been running Windows XP since its release, been using SP3 since ... Reboot right before you try to install SP3. ...
    (microsoft.public.windowsxp.basics)