Transactions for MSAccess with VB.NET

[parminder]

Hi all big players,

Here is a problem I would like to ask:

Can I use Transactions for MSAccess database in VB.NET

Like DBEgine.BeginTrans, Rollbacks and DBEngine.CommitTrans in VB6 for MSAccess with DAO [not ADO]

If not then how can we control Batch updations.

Thanks

Parminder

[RichardAtherton]

not tried it but I would say a defintie yes, remember ADO.Net actually doesn't care which database you use. I do have one concern though, we used oledb in our application development, still linked to sql server (in our native application) but I've heard rumours that that support is being withdrawn, pisses me off because we could have gone for native sql and was only adopted oledb as a customer convenience if they already had a different type of database installed, e.g. FoxPro, Oracle, etc.

[parminder]

Thanks Richard

Is you have code example ?

[Cander]

No.

Access does not support Transactions.

[Desbaratizador]

What do you mean ?

- That an Access database does not support transactions (wrong) or that programming Access databases with ADO .Net is incompatible with transactions (wrong too), example:

Dim CN as OledbConnection
Dim Trans as OledbTransaction

'Open your connection

Trans = CN.BeginTrans

Try
'Code to update database

Catch
Trans.RollBack()
'Close connection
Throw
End Try

Trans.Commit()

'Close connection

[parminder]

Thanks Desbaratizador


I am using transactions in MS Access. Definately it is working fine.

Thanks for your code and help