Re: Access 2000 needs to be repaired EVERY day

There was an ancient problem in Win 2000 Server, caused by a setting called
something like Opportunistic Locking (nothing to do with locking in Access),
but that was fixed yonks ago, SP2 or 3 for Win 200 Server IIRC.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns982FB1C231622f99a49ed1d0c49c5bbb2@xxxxxxxxxxxx
"(PeteCresswell)" <x@xxxxxxxxx> wrote in
news:05qbf2dqjghrr9ifls93q1klh2q64fkraa@xxxxxxx:

For me, the low-hanging fruit would be the file server: move the
application to a different server and cross your fingers. Dunno
the exact nature of a server problem that can cause corruptions,
but I've had a couple of instances where changing servers stopped
the problem right away and permanently.

I've never seen anything like that. In my experience, the corruption
is almost always caused by software on the workstations, i.e.,
substandard versions of Access and Jet.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/


.

Relevant Pages

  • Re: Tableupdate question
    ... network with no servers and I believe they are all running XP. ... > Opportunistic locking was a scheme introduced back in the Novell days (so ... > the only process using that file would lock the file and not worry about ... > both server and workstations the problem have ceased and the app is now ...
    (microsoft.public.fox.programmer.exchange)
  • RE: OPPORTUNISTIC LOCKING, SIDE EFFECTS ON A FILE SERVER.
    ... Opportunistic Locking is really just a performance related thing. ... for a contact database. ... On the ACT! ... Database on the Server. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Network refresh problems.
    ... If you are running Windows NT/2000/XP on your workstations and or server you ... "opportunistic locking" you will find some interesting articles. ... SBS2000 on the server by disabling opportunistic locking. ... > However in some installations workstations do not ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Offline file resynchronization
    ... Have you tried modifying "Opportunistic Locking" on that server? ... > her and sync up when she gets back in. ... I didn't have time to check the security, ...
    (microsoft.public.win2000.general)
  • Re: Advanced Server: file locking
    ... >> Is there any way to configure Advanced Server so that the file locking ... with other Win clients. ... > 3.11 Disabling Opportunistic Locking ... > Opportunistic locking is enabled by default. ...
    (comp.os.vms)