🚀 go-pugleaf

I occassionally get a List Index out of bounds' error - the number in
brackets following the error varies widely.  I think that the error is
something to do with one of my SQL queries or updates.

I am using ADOQueries to read to and write from an MS Access 2000 database,
with BCB 6 Professional.

I would like to clarify how I should be performing the queries/updates.

I have the main form of my application on which I have placed, at design
time, a TADOConnection.  The main thread in my application creates two other
threads, and it is these that read and write to the database.  Each of the
threads access the same tables.  In my TADOQueries, I specify the parent
form's TADOConnection as the ADOQuery->Connection.  (I believe I should be
doing this to avoid Access's slow write to the database files).

Do I need to have any form of locking mechanism between the two threads to
prevent them from accessing the tables at the same time?  I thought that ADO
is thread safe?

Is this likely to be the cause of my problems?  If not, any other
suggestions?

Thanks

Andrew