Re: Number of locks on Win2000 Server/Database Crash

From: Dave Patrick (mail_at_Nospam.DSPatrick.com)
Date: 12/03/04

  • Next message: Steve Riley [MSFT]: "Re: FTP Passive Mode" 
    Date: Fri, 3 Dec 2004 08:17:58 -0700

    For Windows NT/2000

    Server side, you add a Reg_Dword value named;
    "EnableOplocks"
    and set it's value to 0
    HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters

    Been there did this some years back. Best solution is to migrate the Access
    backends to SQL server and be done with it. 

    -- 
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Bart Steur" wrote:
| Hello,
|
| We are running WIN2000 Server and we have an Access 97 on the server.
| Multiple users use this database very frequently. (for 
Select/Insert/Update
| and Delete)
|
| The database was first situated on a Novell/Netware Server where things 
ran
| fine. Now we have transferred the database to the W2K server and the
| database keeps crashing and we have to repair it al the time.
| On the Novell/Netware server we were able to set the maximum number of 
locks
| per connection and the total number of locks. Since we did this more users
| could use the database together.
|
| Question1: Is this possible for W2K server
| Question2: Could there be another reason for this database crash.
|
| Please help,
|
| Thanks,
|
| Bart
|
|
  • Next message: Steve Riley [MSFT]: "Re: FTP Passive Mode"

    Relevant Pages

    • Re: help with 2000i on win2k server (sp3 on database)
      ... See Leonard's post for the config options. ... If the server is mangling itself, then ANYTHING running on the server ... that I work with will support the database AND the application. ... As for Windows vs. Linux/NetWare, I can agree, but I also see MANY ...
      (comp.databases.btrieve)
    • Re: nt4.5 to w2003
      ... keep in mind that there basically is two different things you can do to move from an NT 4 (SAM Database) domain to an Active Directory Domain. ... You can choose to upgrade the domain from NT 4 to Windows 200x Active Directory. ... The thing to keep in mind here is that you have to Upgrade an NT 4 PDC to Windows 200x. ... You could download and install Virtual Server 2005 if you needed to upgrade an NT 4 machine to Windows 200x and your real hardware either does not support NT 4, or the NT 4 hardware you have does not really support Windows 200x. ...
      (microsoft.public.windows.server.migration)
    • Re: Setting up Linked server to MsAccess
      ... At the server level I have added my windows user group ... At the database level I have added my Server login ...
      (microsoft.public.sqlserver.security)
    • Create SharePoint Portal failed.
      ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
      (microsoft.public.sharepoint.portalserver)
    • Problem with Sharepoint Windows Services on Win 2003 SBS Server
      ... The other day we had a server that crashed for some unknown reason. ... "Cannot connect to the configuration database. ... I should point out at this stage that the OS is Windows 2003 Small Business ... SharePoint Services 2.0 and tried re-installing MSDE by launching ...
      (microsoft.public.windows.server.sbs)
    Loading