Can anybody help me? I'm desperate

I want to use transactions in my application. Using a TDatabase connected
to a local MS Acccess 7.0 database via auto ODBC and calling
Database1.StartTransaction is giving this error messages:

'General SQL error'

I think that this has something do do with the ODBC/BDE configuration. Does
anyone have a working database project with Delphi 2.01 connected to MS
Access using transactions ? Pls send me a copy of the BDE configuration
file or any description.

Thanks
Jesper Olsen

In article <01bc4444$f48edec0$c496b6c2@jows>, Jesper Olsen
<jo_...@post4.tele.dk> writes

I have the following problem using ODBC and Microsoft Access (7.0) with
Delphi 2, any assistance would be much appreciated :-

I get the following error message when trying to start a database
transaction : 'General SQL error. [Microsoft][ODBC Microsoft Access 7.0
Driver]Operation invalid at this time'.

The only way I can start a transaction is to make sure I don't have any
active Queries or Tables, i.e. I can start the transaction, execute my
Query and insert or amend as required and then commit or rollback.

If anyone knows of a solution to this problem then please contact me,
thanks.

--
CCCCCCL P McBride
CMMMMML Tel: +44 (0) 181 563 1003
CM M ML Fax: +44 (0) 181 748 0541
CCCCCCL mcbri...@stanage.demon.co.uk
LLLLLLL ClassMethod Limited