|
commenting to Jason that majority of my work in the 90s was read from one DB write to another DB
via ODBC2JDBC driver
https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers/using-openlinks-odbc-jdbc-bridge-to-access-jdbc-data-sources-via-tableau-windows-edition-89094aa33b7b
that said I think MS missed the boat on 2-phase-commits
https://en.wikipedia.org/wiki/Two-phase_commit_protocol
Also 2 factor DB authentication was not implemented by Access https://en.wikipedia.org/wiki/Database_security
Feel free to ping me offline if you're interested in implementing ODBC2JDBC driver as an option Good Luck! From: bret_stern <bret_stern@xxxxxxxxxxxxxxxxxxxxx>
Sent: Saturday, November 30, 2019 7:14 PM To: pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx> Subject: Re: MS Access Frontend My two cents. Access is awesome. Extremley fast prototyping environment.
Found on most pc's in businesses. Great reporting tools. It is my go-to tool for prototyping DB structures, reports, great import/export tools, and boatloads of people who are glad to share vba code and solutions My only bitch is the dumbing down of the application by Microsoft, Adding bands, and hiding past tools...killing the performance with xml bs..."there, I feel better now" Libre Base does alot of the same things, just a different way. If learning is the point of this discussion, then learn as much as possible about each one. I started using win32 back in odd-06 with ODBC and direct db-api calls, but have steadily drifted towards RAD environments...although there's great satisfaction and control the lower you go. When the prototyping is over , I've been pushing Lazarus as my multi-plateform development environment. It still pisses me off how abused Excel is, but people don't know the difference. Keep on rockin On 11/30/2019 2:34 PM, Jason L. Amerson wrote: > I am a Linux user too. I just bought my children Windows laptops so it would > be easier for them to use. I had to buy me a Windows one too so that I can > do the whole Microsoft Family thing and monitor them a little. But I think > it is time to throw them into the deep end and see if they can swim. > > Jason L. Amerson > > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx> > Sent: Saturday, November 30, 2019 01:52 PM > To: Jason L. Amerson <drjason@xxxxxxxxxxxxxxx>; 'Martin Gainty' > <mgainty@xxxxxxxxxxx>; PostgreSQL <pgsql-general@xxxxxxxxxxxxxxxxxxxx> > Subject: Re: MS Access Frontend > > On 11/30/19 11:04 AM, Jason L. Amerson wrote: >> Thanks Martin. I have decided to go another route. I have nothing but >> problems whenever I use Microsoft products. I personally think that >> Microsoft was shit when it started, and it is still shit 35 years later. >> So, I am just going to take Windows off my computers and put Linux on >> them and just use a different client. > > I'm a Linux user and I applaud your move. Just be aware you will not find an > Access replacement on Linux. You will find things that have subsets of its > functionality, but not a drop in replacement. > > >> >> Jason L. Amerson >> > > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxxxx > > > > > |
