Re: ADOBD / JET Transaction Problems

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 09/28/04

  • Next message: Gareth Sharp: "Re: ADOBD / JET Transaction Problems" 
    Date: Tue, 28 Sep 2004 18:03:17 -0400

    I think it's probably more relevant to post the transaction-related code
    you're using.

    It looks as though you're trying to use both DAO and ADO concurrently. It
    doesn't work that way: what you'll end up with is, in essence, two separate
    threads that don't know anything about each other. 

    -- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Gareth Sharp" <gs@paxsoft.co.uk> wrote in message
news:cjc0eu$2i$1$8302bc10@news.demon.co.uk...
> Hi all!
>
> Firstly, I am using VB5, a password protected Access 97 database, DAO3.6,
> and ADO2.8
>
> I am trying to overcome page level locking using an Access 97 database, by
> using ADODB to open the database to use record level locking.
>
> This seems to work fine, but the transactions seem to not be working
> properly.  If I use BeginTrans, then do 3 "INSERT INTO " queries, then
> Rollback, the Rollback does not Rollback the transactions - all 3 are
> processed, and committed to the datebase.  I have tried changing it to
> cnn.BeginTrans, etc.
>
> The following is the code that I am using to open the database - is there
> anything obviously wrong with this?
>
>     Global gCurDb As Database
>     Global wsDAO As DAO.Workspace
>     Global cnn As ADODB.Connection
>
> Public Sub OpenDB
>
>    Set cnn = New ADODB.Connection
>    cnn.Provider = "Microsoft.JET.OLEDB.4.0"
>    cnn.Properties("Data Source") = "v:\data\TestDatabase.mdb"
>    cnn.Properties("Jet OLEDB:Database Locking Mode") = 1 ' record level
> locking
>    cnn.CursorLocation = adUseServer
>    cnn.Properties("Jet OLEDB:Database Password") = "123456"
>    cnn.Open
>
>    Set wsDAO = DBEngine.CreateWorkspace("WorkSpace", "Admin", "",
dbUseJet)
>    Set gCurDb = wsDAO.OpenDatabase(DBFile, False, False, ";pwd=" &
> gDBPassWord)
>
> End Sub
>
>
> All the best!
> Gareth Sharp
> Technical Director
> Paxton Computers Ltd
> website: http://www.paxsoft.co.uk
> eMail: mailto:gs@paxsoft.co.uk
>
>
  • Next message: Gareth Sharp: "Re: ADOBD / JET Transaction Problems"

    Relevant Pages

    • Re: ADOBD / JET Transaction Problems
      ... I think it's probably more relevant to post the transaction-related code ... > using ADODB to open the database to use record level locking. ... > Rollback, the Rollback does not Rollback the transactions - all 3 are ...
      (microsoft.public.data.ado)
    • Re: Transaction Errors
      ... I didn't realize that the DBI version was so ... >>I keep getting this error when attempting to utilize a database that has Innodb ... >>Transactions not supported by database at module..... ... >>until the commit is called, of if an error occurs, the rollback is called. ...
      (perl.dbi.users)
    • Re: Using SqlTransaction with MSSQL Trans?
      ... I believe you will get separate transactions and transaction from the ... application will not be able to rollback changes in a database. ... Val Mazur ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Do Transactions guard against corruption?
      ... when the database is opened and closed. ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ...
      (microsoft.public.access.modulesdaovba)
    • Re: Do Transactions guard against corruption?
      ... Have you ever had a database in a 'suspect' state? ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ...
      (microsoft.public.access.modulesdaovba)