If I add a new record, then post it, then try editing the record I just
added, and then try and post if again I get the following error "The
specified row could not be located for updating.  Some values may have been
changed since it was last read"

Any ideas?

Thanks in advance.

Richard Mace

The reason I have to ask is that you say you are using *both* an "ADO
table" and a "normal Delphi dataset". The two just do not mix -- the stock
Delphi dataset components use the BDE, not ADO.

I must admit, I am a "little" puzzled about which components I need to use
to connect to the .mdb file.

Thank you for your time.

Is your original in a multi-user environment? Or where you getting the
update error when in a single-user environment? The problem suggests update
concurrency that one would experience in a multi-user environment with a
database that uses an optimistic locking scheme.

(Follow-ups to the newsgroup only, please.)

It was a "single user" environment on my development PC.  I can reproduce it
100% of the time.

I am using the components I mentioned, because I can't figure out any other
way of connecting to the data.
If I use a TADODataSource component, it want's it's own datasource which it
appears to want to get from a normal Delphi datasource.

I have learnt one thing.  If the access database is create using Access 97
then the error occurs as I mentioned earlier if I edit a DBEdit field of a
DBCheckbox.  However, if I create the original Access database using Access
2000 (which I thought "may" be my problem, and then try Editing the record
I've just added via the DBEdit it works fine BUT DBCheckbox causes the same
error.

I am now really confused, and am not sure whether it is a combination of
components that I am using that is wrong or if their is a bug in the ADO
components or if their is another bug in the MDac.

I have been looking for articles on the web that describe how to use ADO,
but I can't find one that talks about connecting to an .mdb file.

Thanks in advance.

Richard Mace