To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44645
------- Additional comments from [EMAIL PROTECTED] Thu Mar 10 08:56:49 -0800 2005 ------- Hi :) I'm going to attempt to give you a reproducable model. This is for Windows XP running on an x86 FrameWork using Intel Pentium 4 technology Probably the cause of this whole mess is that the links between objects in forms and tables and views are not updated properly when objects are changed. It could be something else but that's how it appears to me. Otherwise it all "appears" to work right. Reproduction ------------------- Load Open Office QuickStarter if it's not already running Load Open Office Base, and say hey. I want to start a new database! Yep. Registered. Great. Hmm. Okay. It's created. First problem! Something is changed during the creation process and the file SHOULD be saved over again after the process is done, but it's not, and the save icon is greyed out. You must add content first. Otherwise the file won't open if you restart the comp. Okay. Let's assume you do restart the computer. OMG! Open Office failed to save the Database File. *shocked*. Though you can cancel this and should be able to load the file. In fact do cancel, otherwise you'll load a corrupted file. The last saved state of your file from the HDD should appear to work fine. But the recovered version won't. So there's issue #1 out of the way! Now your file is re-opened after you've restarted the computer. What to do next. Hmm. Hey! Let's create a table! Doo-de-doo. Making a table with fields, and let's give it a few pieces of data. That looks great! Save the file again, and restart the comp! Oops! OOo crashed again. Hey. No biggy the file was saved, right!? Let's hope so! Re-load OpenOffice Base and let's add a table view and a form. First the table view. I'm confused about the index key. Could this be causing registration issues? or a failure to access database table views and forms if they aren't set up right? I used the Form Wizard to base my form on the original table mentioned earlier, and the table view was also based on the original table. So the table view is setup. Let's setup the form based on the table. Bearing in mind of course, all these elements so far MUST have different names and labels, or OOo will turn it's nose up and say. Hey! I ain't doin' that. You already have a form with that name. It doesn't seem to differentiate at processing level between a table, form, or table view, or form view. There's issue #2 out of the way. Okay. let's restart the PC. *waiting* Hey. There's windows. Awww. OOo crashed and failed but it saved the database file. Oh. I forgot to mention, do not recover the corrupted data from the restore engine. It won't work! The saved file is corrupted! I made this mistake myself a few times... too many. Load up your file into OOo base again. Hmm. Let's enter some data into the new form that was hopefuly created using the form wizard. This all goes fine and dandy. I haven't found any problems entering data into the form or into the table. Save the file! Now. Hmm. I don't need that table but I do need the form. Okay. So let's backup this file first. Copy / Paste. Mhmm. Done. Okay. So we inserted data into the table! Remember that. Okay let's erase the table, and save the file. Now close OOo base, and re-load the file. Hey. It seems to work fine until... Go ahead and try to open the form. :O Object failed to load. Link to temporary data not established. Table not found. Table View not Found. Index key not found. Failed to register with Data Sources. The error report goes on and on. Okay. Let's exit OOo and restore the original file. Restar the computer. Hey look. OOo crashed. Neato. Don't restore the file. Let's go into OOo base, using our file and enter some data into our new form. Here we go. Entering data. Okay. Now save the form. Exit OOo base, and reload your saved file. It looks fine. Now erase the form. shocking! It either can't! Or Ooo will crash. No errors will be given. This same event occurs when a form created through the form wizard is changed and then altered manualy. This alteration could be as simple as un-grouping a set of objects, and then saving the file. Sometimes it saves, and sometimes it doesn't save. If you restart the computer now, you get the same ol' crash report, and hey. My file loaded from the HDD!... Or did it? Go and try to modify your table. Yikes! It won't let you! Says the data in the form can't be found. But how! The objects don't link properly anymore! Probably the cause of this whole mess is that the links between objects in forms and tables and views are not updated properly when objects are changed. It could be something else but that's how it appears to me. Otherwise it all "appears" to work right. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
