Access 2000, VB6, ADO2.5 - Multiuser Environment

[Santosh]

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

[Nguyen Khanh]

"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
>
>

[databoy]

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
>>
>>
>

[prashant pamani]

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,