Den 2011-06-02 15:15 skrev heineferreira såhär:

> In one of the posts in this group somebody said that even reads in
> Firebird occur as a transaction. I as able to read, insert, update and
> delete records in Firebird using Access 2010 and the ODBC driver using
> linked tables WITHOUT using any transactions. Is there something that I
> ought to know perhaps? Does the Firebird ODBC driver use implicit
> transactions or does Access 2010 do something like that?

Not sure "who" starts the transaction but Firebird ALWAYS starts a
transaction for ANYTHING.

Not sure it's something you need to worry about, but keep an eye on the
oldest interesting transaction to make sure your app doesn't leave
transactions open. It will cause a huge buildup of garbage in the long run.

Examine Firebird FAQ/docs about "sweep", "garbage collection", "oldest
interesting transaction".

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64