Multiuser in MsAccess

Results 1 to 6 of 6

Thread: Multiuser in MsAccess

  1. #1
    Venkateswarlu Guest

    Default Multiuser in MsAccess

    Dear sir<BR><BR>we got a problem in my application using ADO&#039;s and Ms Access as backend in multiuser.We are not able to Generate Tansaction number.Same number is giving for different users and while saving it,giving unique constraint voilation.So please help me <BR>how to lock the record or table using ADOs and MsAccess.<BR><BR>thanking u <BR>

  2. #2
    prakash Guest

    Default RE: Multiuser in MsAccess

    well...<BR><BR>I had read something like Access will not support more than 10 concurrent sessions.<BR><BR>first of all what kind of ID are you looking<BR>is it a autonumber.<BR>or you are manually assigning one...??<BR><BR>Let me know more...about it...

  3. #3
    venkateswarlu Guest

    Default RE: Multiuser in MsAccess

    Thanku prakash<BR>We are generating autonumber<BR>ie continuoisly starting from 1 .

  4. #4
    prakash Guest

    Default what is the problems...

    it automatically does ..??

  5. #5
    venkateswarlu Guest

    Default RE: what is the problems...

    Problem is it is giving same number to different users<BR>if at all they access at a time.that means the locking system is not working,we are not able to handle that.<BR>

  6. #6
    J Guest

    Default RE: what is the problems...

    Locking in access is poor, upgrade to SQL server.

Posting Permissions

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