Re: Could not update; currently locked error

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks a lot.

"Ralph" wrote:


"Andriy" <Andriy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B11FC969-6E4C-4AF9-8AAF-307297D87C57@xxxxxxxxxxxxxxxx

As far as I understand Jet OLEDB:Database Locking Mode is the property.
From MSDN:
DBPROP_JETOLEDB_DATABASELOCKMODE Type: VT_I4
Typical R/W: R/W

Description: Jet OLEDB:Database Locking Mode

Scheme to use when locking the database.

Constants:

DBPROPVAL_DL_OLDMODE - Old mode used in previous releases of Jet's storage
engine
DBPROPVAL_DL_ALCATRAZ - Alcatraz mode. Enables locking mode that allows
for
row-level locking. This does not preclude page locking.
A database can be open in only one mode at a time. The first user to open
the database determines the locking mode used while the database is open.

I suppose if the values start with 0, the 2nd one has the value 1. Am I
right?


You are correct:
// DBPROPSET_JETOLEDB_DBINIT DBPROP_JETOLEDB_DATABASELOCKMODE Enumeration
Values
// Original Jet Database Locking Scheme
#define DBPROPVAL_DL_OLDMODE 0x00
// Alcatraz Technology - enables row-level locking
#define DBPROPVAL_DL_ALCATRAZ 0x01

You might find this handy...
http://www.vrac.iastate.edu/~kevint/bin/DevStudio%20Patches/MSDevStudio6-sp5/msjetodb.h

hth
-ralph



.

Relevant Pages

  • Re: Could not update; currently locked error
    ... Asynchable Commit = False ... Catalog Term = Database ... Provider Friendly Name = Microsoft OLE DB Provider for Jet ... As far as I understand Jet OLEDB:Database Locking Mode is the property. ...
    (microsoft.public.data.ado)
  • Re: Could not update; currently locked error
    ... Description: Jet OLEDB:Database Locking Mode ... Scheme to use when locking the database. ... A database can be open in only one mode at a time. ...
    (microsoft.public.data.ado)
  • Re: Where is documentation on connection strings?
    ... > See the Jet OLEDB:Database Locking Mode=1? ... The Jet OLEDB:Database Locking Mode property can be set to any of the ... A database can only be open in one mode at a time. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: OleDb Connection String For MS Access 2007 Clarification.
    ... Thank you kindly Mark, also by your reply I put a particular 'token' into Google ... (like Jet OLEDB:Engine Type) ... |> Jet OLEDB:Database Locking Mode= ... | Jet OLEDB:Database Locking Mode=0; ...
    (microsoft.public.dotnet.framework.adonet)