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.
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 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.
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
