Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Question Unanswered: Question on number of users

    I'm working with a client that experiencing database corruption repeatedly (many times during the day). The office has 13 workstations and the server. Any one, or all, of the workstations could be in the database at the same time. The technician for the office is saying that the corruption is due to the number of users in the database. I can't find any documentation that says that there is a user limit for access and 13 users sounds awfully low.

    Is there a user limit that would effect the stability of the db? If so, what is it and is there any documentation for it?

  2. #2
    Join Date
    Nov 2002
    Posts
    150

    Re: Question on number of users

    13 is not too many. What type of corruption is taking place?

  3. #3
    Join Date
    Jan 2003
    Posts
    3
    3343 errors. Easily fixed with jetcomp but not convenient for the customer. Thanks for the info.

  4. #4
    Join Date
    Nov 2002
    Posts
    150
    Originally posted by dchiz00
    3343 errors. Easily fixed with jetcomp but not convenient for the customer. Thanks for the info.
    Since it is multiuser, this could be it (one of the things that cause a 3343): A commit is pending from another user, but the lock file cannot be found.

  5. #5
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    you should look at LOCKS in the system on the machine, where you have MDB. By LOCKS I don't mean any MS Access stuff, it is pure system problem.

    I really recommend to use Win2k Server. It has much better LOCKS that old WinNT.

    check this for little info about LOCKS

    http://msdn.microsoft.com/library/de...stic_locks.asp



    jiri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •