Den 2011-05-31 21:53 skrev heineferreira såhär:

> I used the Employee sample database in Firebird 2.5 with the latest odbc
> driver. I linked those tables to an Access front end and was able to
> select, insert, update and delete data with both DAO and ADO.
> So far it looks like locking and the MGA seems to be working.

What, exaclty, do you mean by "locking"? Is this something you actively
do in Access to prevent concurrent access to a record?

If so, then I think you can ignore locking (don't need to do it) on the
FB tables. Firebird ALWAYS locks a record that's been updated until you
commit the transaction.

You should shift from thinking in terms of "locking" to thinking in
terms of transactions. Locking is Access, transactions is Firebird.

Not sure how you work with transactions from inside Access, though.

> I haven't tried to do this in a multi user environment but since you say
> that readers don't block writers and writers don't block readers and
> that a problem only occurs if two writes try to write to the same record
> at the same time. You also said that the MGA works all the time and
> cannot be switched off. Very valuable info indeed. Thanks. H.F.

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