>Hi,
>
>So, I need to write a Software that juste update some Paradox Table (indexed) and I can't write in these table.
>
>I am unsing a simple ADOBD connection and a ADODB recordset. The recordset ADDNEW method create a new record, I am using the recordset UPDATE method, but when I quit my form, I loose all adds. I tryed to use the connection's BEGINTRANS and COMMITTRANS method, but I got a error message. What's wrong?
Not sure about Paradox but I know that not all database engine are supporting transactions.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com