ADO + Connection + Transactions + Access + ASP

[abcd]

I will be using ASP pages and connect to access DB. Does access support ADO
transactions through ASP pages?

thanks

 

[Danny J. Lesandrini]

When you say "transactions" do you mean transactions, or do
you mean INSERT, UPDATE and DELETE statements?

I wrote up an article that shows (a little crudely) how to insert,
update and select records from an Access database from ASP.

The download includes a form that, when imported into your
application, will create the ASP page with code to do the above.

As for Transactions, that may be handled in ADO as well, though
I don't remember the syntax off the top of my head. Whatever
it looks like, it will undoubtedly look something like this:


cnn.BeginTransaction

cnn.Execute strSQL
If Err.Number = 0 Then
cnn.CommitTransaction
Else
cnn.RollbackTransaction
End If

Is this the syntax you're looking for?

 

[Danny J. Lesandrini]

FWIW

Search Google Groups for ADO Connection Transaction and
you'll find plenty of old posts on using Transactions with ADO
and ASP pages. (in the ASP newsgroups.)

http://groups.google.com/group/micr...on+group:*asp*&rnum=19&hl=en#e8748a8ee9b993fb

 

[abcd]

Thanks Danny.

Yes you are right. I was looking ofr Begintrans syntax and you have
explained very well.

my another question is that is Access transaction based database system?

if I use beginTrans of ADO connection connection object with Access as
backend am I be getting the same effect as connecting to SQL Server which is
Transactional DBMS

 

[Pieter Wijnen]

yes it is

Pieter

Thanks Danny.

Yes you are right. I was looking ofr Begintrans syntax and you have
explained very well.

my another question is that is Access transaction based database system?

if I use beginTrans of ADO connection connection object with Access as
backend am I be getting the same effect as connecting to SQL Server which
is Transactional DBMS