2007/10/10, Drew Jensen <[EMAIL PROTECTED]>: > > Johnny Rosenberg wrote: > > Hi. > > > > I have an odb file, previously connected to an sxc file. However, after > > adding an extra record to the sxc file, I saved it as ods instead and > > deleted the sxc file. So I figured that I have to "assign" the new file > to > > the odb file, right? And I tried to but failed. I tried Edit - Database > - > > Properties, and I selected the new file. However, base didn't care, it > was > > still connected to the sxc file which doesn't even exist. > > Next I tried Edit - Database - Connection type, but that failed the same > way > > too. > > > > If I am not supposed to edit those things, why can I edit the > corresponding > > fields in those dialogues? Looks like a bug to me, or did I miss > something > > again? Is the only way to obtain this to just start all over again from > > scratch, connecting a new database to the new spreadsheet? > > > > That's what I am going to do anyway, but still, if this is a bug I think > it > > needs to be corrected. It's frustrating anyway. When I change something, > > whatever it is, I expect my changes to take place. If not, I must not be > > able to change any fields which look like they are going to do things > for > > me. That only creates frustration. I will be happy to file a bug report > > about this if no one tells me that I am wrong and that it is actually > not a > > bug. > > > > Johnny Rosenberg > > > > > Hi Johnny, > > Well, two things - first after making a change to the properties like > that you need to refresh your table view. > First click on the Tables icon on the left side of the window, this > turns the context menu needed enabled.
I couldn't do that. That icon didn't "respond". The previous selected icon was still selected. Then select the menu item View->Refresh Tables. > > That should establish a new connection using the new properties. > > That said, there where some issues with connection objects being cached > by the Java engine and not released. For example you may close the > database and reopen it, and still the connection did nt refresh, if you > are on a Windows machine... No, Ubuntu 7.04, the latest Ubuntu release of OpenOffice.org (2.2.0). ...and any other OpenOffice.org file or utility ( > quickstarter ) included was left in memory while the odb file was > closed. In these cases your simply need to close all OpenOffice.org > objects and then restart the application. This will force the creation > of a new connection. I restarted Base a few times with no better result than before. I guess I have to do some more experiments to see what really happen. At least I know now what SHOULD happen... HTH > > Drew > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
