Access 2000, VB6, ADO2.5 - Multiuser Environment


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Access 2000, VB6, ADO2.5 - Multiuser Environment

  1. #1
    Santosh Guest

    Access 2000, VB6, ADO2.5 - Multiuser Environment


    Hi ,
    I am using Access 2000, VB6, ADO2.5 in a Multiuser Environment for my project
    .. When ever I try to make a connection or Update or Insert from more than
    one user I get an error -2147467259 (80004005) Database is opened in read
    only mode ..

    I am not able to rectify this error. I refered the MSDN bug center but no
    clear answer for it .

    Can any one help me. (Code sample is welcome)

    Thanks in advance.

    Santosh



  2. #2
    Nguyen Khanh Guest

    Re: Access 2000, VB6, ADO2.5 - Multiuser Environment


    "Santosh" <santosh@focusite.com> wrote:
    >
    >Hi ,
    >I am using Access 2000, VB6, ADO2.5 in a Multiuser Environment for my

    project
    >.. When ever I try to make a connection or Update or Insert from more than
    >one user I get an error -2147467259 (80004005) Database is opened in read
    >only mode ..
    >
    >I am not able to rectify this error. I refered the MSDN bug center but no
    >clear answer for it .
    >
    >Can any one help me. (Code sample is welcome)
    >
    >Thanks in advance.
    >
    >Santosh
    >
    >



  3. #3
    databoy Guest

    Re: Access 2000, VB6, ADO2.5 - Multiuser Environment


    Nguyen...

    Is the connection object set for read and write?
    Are the recordsets set to use static cursors on the client side?
    Are the recordsets opened in optimistic or batch optimistic mode?

    All conditions must be met to use ADO with Access.

    There is nothing special about that error message... If you do much VB and
    ADO programming, you'll see it often.

    -Carl



    "Nguyen Khanh" <khanh1410@yahoo.com> wrote:
    >
    >"Santosh" <santosh@focusite.com> wrote:
    >>
    >>Hi ,
    >>I am using Access 2000, VB6, ADO2.5 in a Multiuser Environment for my

    >project
    >>.. When ever I try to make a connection or Update or Insert from more

    than
    >>one user I get an error -2147467259 (80004005) Database is opened in read
    >>only mode ..
    >>
    >>I am not able to rectify this error. I refered the MSDN bug center but

    no
    >>clear answer for it .
    >>
    >>Can any one help me. (Code sample is welcome)
    >>
    >>Thanks in advance.
    >>
    >>Santosh
    >>
    >>

    >



  4. #4
    prashant pamani Guest

    Re: Access 2000, VB6, ADO2.5 - Multiuser Environment


    Hai santosh

    I pass through situation which you define in this matter pleasse open the
    recordset in adokeyset and lock type to batchoptimistic please try out this
    If you satisfied please email to me,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center