ADO 'adLockPessimistic' does not work for MSAccess databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fritz Jahns - 18 Nov 2004 11:09 GMT

Hello,
in my application (developed under Visual C++ 6.0) I work on a MSAccess
database (.mdb)
with ADO routines in a multiuser environment.
In some special case I want to update an attribute in a table: read the
value, calculate a new value
and rewrite it to DB. For the time between reading and the end of the
update the table (or just the one attribute)
shoul be locked so that no other user can access the data.
Unfortunately the 'adLockPessimistic' parameter of the (_RecordsetPtr->)
open statement does NOT deliver the
desired behaviour. According to MSDN Library this is not a bug but
really a feature; the setting
is converted to 'adLockOptimistic'.
Does anybody have an idea how to lock a MSAccess DB with ADO, C++?

Thanks in advance

Fritz Jahns
University of Bonn, Germany

Reply to this Message

Mona \(Grapecity\) - 23 Nov 2004 09:10 GMT

Hi Fritz,

A similar problem has been stated as a bug on Microsoft site, the link is
here :

http://support.microsoft.com/default.aspx?scid=kb;en-us;190625

You can go through the article and if your problem relates with this then
you can download MDAC 2.8 from the following link

http://msdn.microsoft.com/data/downloads/updates/default.aspx

HTH

Mona

> Hello,
> in my application (developed under Visual C++ 6.0) I work on a MSAccess
[quoted text clipped - 16 lines]
> Fritz Jahns
> University of Bonn, Germany

Reply to this Message