I'm having a serious, and very hard to notice, problem with the
reliability of updates to a database. I have a .dbf file linked to an
.odb file, and when updating from queries in the database the changes
are (occasionally) applied to the wrong record. I haven't been able to
isolate what causes the problem, although I suspect it has to do with
there being no way to specify a key field. Because the problems are
unpredictable and can easily be missed, I have to either give up on Base
entirely, or find a reliable way to do the updates. I really want the
ability to query, this is a large and active database that needs to be
looked at in different ways. There is only one table involved, though.
Is there some way I can capture the table into the .odb file directly,
and then add an auto key? Or does anybody have any other suggestions?
This issue is a real killer for me, and I'm under a lot of time
pressure (have to get the current crop of updates done by tomorrow
morning, and it's after 9 pm here now).
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
