Jet OLEDB: Database Locking Mode

From: Andy Willis (andrewrwillis_at_blueyonder.co.uk)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 10:40:56 -0000

The Jet OLEDB: Database Locking Mode is set to 1 in the Advanced tab of the
Connection to my Access MDB on my import DTS Local Package.
I have not been able to find what this setting is or any other for that
matter

My problem is that my DTS package runs fine as a scheduled job if noone is
in the MDB database but fails if someone is in the MDB. This makes me think
that for some reason the SQL DTS job is trying to open the Access database
exclusively before it does the data import.

Also what should the Mode setting be as a number for shared access.

I guess this could also be a problem amending the LDB if someone else has
already created it, but I think that unlikely because if the LDB can be
created (scheduled job runs fine of noone in MDB) then you would expect it
to be able to be amended.

Regards
Andy Willis

Relevant Pages

  • Re: Jet OLEDB: Database Locking Mode
    ... You can make sure your DTS is not locking by putting: ... Share Deny None-Neither read nor write access can be denied to others. ... local user has Access set to open mdb files exclusively. ... database open with Share Exlusive. ...
    (microsoft.public.data.ado)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: temp db
    ... If the database is not in use, you can create a copy just by copying the MDB ... The purpose is to create a temp db for all the ... ' This subroutine illustrates how to use a temporary MDB in your app. ...
    (microsoft.public.access.formscoding)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
  • RE: Access to Access Automatic Updates
    ... MS Office Master 2000 ed. ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)