Number of locks on Win2000 Server/Database Crash

From: Bart Steur (solnews_at_xs4all.nl)
Date: 12/03/04 

Date: Fri, 3 Dec 2004 11:04:52 +0100

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

Relevant Pages

  • 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)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
Loading