On 07/27/2007 07:17 PM, Barbara Duprey wrote: > 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).
Barbara, not sure exactly what the problem is or what you need to do, but two suggestions: 1. Try your question on the database mailing list as those folks pretty much live & breath Base: http://dba.openoffice.org/ http://dba.openoffice.org/servlets/ProjectMailingListList Note: [EMAIL PROTECTED] 2. If you can see the link in tables, right click on the table and click open. You can then manually edit if necessary. Hopefully that will get you through until you have time to help troubleshoot the problem. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
