At 03:34 AM 29/11/2004 +0000, you wrote:

>I am trying to switch a simple MS Access application from MySQL to
>Firebird. I can connect and retrieve data sample data (entered using
>IBAccess when I created the database/table), but cannot modify any
>rows interactively, or with an SQL statement (Query). MS Access
>reports that "The recordset is not updateable".

So, what does the query statement look like?

>I assume that the ODBC driver handles the details of transactions, is
>this correct?

Well, an appropriate ODBC driver would do so...but this isn't to do with
transactions. It relates first to the structure of the output produced by
your SELECT statement and after that, the way your data access interface
implements a "live" recordset (or even, *IF* it does..).

>I have the IBPhoenix documentation, but have not found anything to
>help me solve this problem.

An essential part of solving a problem is describing it adequately. As a
minimum, you'd need to provide the query statement and the definition of
the underlying table(s), including the key constraints. Also say which
ODBC driver you are using.

./heLen