On 11/7/2022 3:42 PM, Rob Sargent wrote:
> Care to share some of the ways the app stopped working? You might
get a leg up on where best to remediate.
I don't recall, as that was a few months ago.
We are running MS-Access as a front end with Postgres as the back end.
It appeared to read and write data perfectly fine, but failed in the
business logic on the Access side where there didn't appear to be any DB
involvement. But switching to v14 caused it and switching away fixed it.
No obvious cause that I could see.
As written, switching databases was very time-consuming.
Since then, I've rewritten the app so that the network admin just
changes an INI file that the app reads on start up.
If there is a change, it switches all the tables over in about 15 seconds.
We wanted that ability anyway in case we ever needed to switch to using
the backup server.
Now, I am working on getting replication going.
Next up: back to upgrading.
But, since you ask, I'll post here when I get back to that so y'all can
follow along as I narrow it down to a specific version.
