When I point my odb file to a new server, I lose my Form

English
,
#1

Hi Everyone,

I have a problem:

I have an .odb file that points to a remote server running PostgreSQL v12. I have been notified that we need to upgrade to v16, so the data has been transferred to a new server, with a new address and password, with the upgraded software.

I can attach a new .odb file to the new server without any problem, but when I try and get my existing .odb file to point to the new server (Edit / Database / Properties / Advanced Properties tab and change the address) when I test the connection using the test connection button all seems well, but when I return to the application window the form area is now blank. All the code is contained in the form.

It should be possible to point to a new server without losing my work…

Has anyone else come across this problem? Does anyone have a solution?

Best wishes,

CB

#2

The form is a special Writer document embedded in the Base document.
Instead of connecting another Base document, you can reconnect the old one to the new URL via Edit>Database>Connection or Edit>Database>Properties.
Alternatively, you may copy all icons of queries forms and reports from the old Base document to the new one.

#3

I sometimes switch connections between several registered datasources. After the change no tables are shown, but changing to another tab like queries, then back to tables shows my tables and other data.

IMHO it is possible, but the change is not autodetected. (I never tried with open forms…)

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.