Horton

Thread

  1. MS Access Frontend

    Jason L. Amerson <drjason@alphagenius.org> — 2019-11-29T17:23:14Z

    
I am trying to setup MS Access as a frontend so that it would be easier on
my wife and children to interact with PostgreSQL. I looked online for some
tutorials but the ones I found are out-date or only pick up after Access is
connected to PostgreSQL. I was wondering if someone knew of some updated
material that they could point me to or maybe walk me through it. I have
used Access quite a bit years ago and things have changed since then. I know
I must install the ODBC drivers, which I have already done. I have already
setup the DSN and I clicked on test and it says everything is fine. I know
that my next step has something to do with Linked Tables in Access, but I am
not sure how to set it up. I guess that is where I start to need help. The
client computers using the frontend will be running Windows 10 and Office
365, both are updated to the latest versions.

 

Thank you,

 

Jason L. Amerson

  2. Re: MS Access Frontend

    Adrian Klaver <adrian.klaver@aklaver.com> — 2019-11-29T17:30:48Z

    On 11/29/19 9:23 AM, Jason L. Amerson wrote:
> I am trying to setup MS Access as a frontend so that it would be easier 
> on my wife and children to interact with PostgreSQL. I looked online for 
> some tutorials but the ones I found are out-date or only pick up after 
> Access is connected to PostgreSQL. I was wondering if someone knew of 
> some updated material that they could point me to or maybe walk me 
> through it. I have used Access quite a bit years ago and things have 
> changed since then. I know I must install the ODBC drivers, which I have 
> already done. I have already setup the DSN and I clicked on test and it 
> says everything is fine. I know that my next step has something to do 
> with Linked Tables in Access, but I am not sure how to set it up. I 
> guess that is where I start to need help. The client computers using the 
> frontend will be running Windows 10 and Office 365, both are updated to 
> the latest versions.

This might help:

https://support.office.com/en-us/article/Manage-linked-tables-1d9346d6-953d-4f85-a9ce-4caec2262797


> 
> Thank you,
> 
> Jason L. Amerson
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

  3. Re: MS Access Frontend

    Tim Clarke <tim.clarke@minerva.info> — 2019-11-30T11:15:00Z

    On 29/11/2019 17:30, Adrian Klaver wrote:
> On 11/29/19 9:23 AM, Jason L. Amerson wrote:
>> I am trying to setup MS Access as a frontend so that it would be
>> easier on my wife and children to interact with PostgreSQL. I looked
>> online for some tutorials but the ones I found are out-date or only
>> pick up after Access is connected to PostgreSQL. I was wondering if
>> someone knew of some updated material that they could point me to or
>> maybe walk me through it. I have used Access quite a bit years ago
>> and things have changed since then. I know I must install the ODBC
>> drivers, which I have already done. I have already setup the DSN and
>> I clicked on test and it says everything is fine. I know that my next
>> step has something to do with Linked Tables in Access, but I am not
>> sure how to set it up. I guess that is where I start to need help.
>> The client computers using the frontend will be running Windows 10
>> and Office 365, both are updated to the latest versions.
>
> This might help:
>
> https://support.office.com/en-us/article/Manage-linked-tables-1d9346d6-953d-4f85-a9ce-4caec2262797
>
>
>
>>
>> Thank you,
>>
>> Jason L. Amerson
>>
>
>
That will help you manage once you have created some linked tables, but
to create them:

1) Click "External Data" from the top Access menu, then "New data
source" on the left

2) Pick "From other sources" at the bottom and as you correctly
identified "ODBC Database".

3) From the dialogue box, change the default of the two options to the
bottom one "Link....by creating linked table"

4) Next pick your created DSN from the "Select data source" dialog

5) You should then see the list of tables etc from your Postgres database

Troubleshooting; make sure you have an ODBC 32 or 64 bit version
matching the 32 or 64 bit MS Access installed.

If you use any security at the MS Access level you will need to set up a
simultaneously shared central system.mdw file in some repository. Don't
try to get more than 6-7 people using this at the same time, it breaks.

Good luck.


--
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420



Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/



Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom

________________________________

Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.

  4. Re: MS Access Frontend

    Tim Clarke <tim.clarke@minerva.info> — 2019-11-30T14:07:24Z

    On 30/11/2019 19:04, 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.

Jason L. Amerson


+1

Libreoffice has a quick and easy database front end. Not great but functional and effort free.

--
Tim Clarke



Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/



Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom

________________________________

Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.

  5. Re: MS Access Frontend

    Adrian Klaver <adrian.klaver@aklaver.com> — 2019-11-30T14:53:21Z

    On 11/30/19 3:15 AM, Tim Clarke wrote:
> On 29/11/2019 17:30, Adrian Klaver wrote:
>> On 11/29/19 9:23 AM, Jason L. Amerson wrote:
>>> I am trying to setup MS Access as a frontend so that it would be
>>> easier on my wife and children to interact with PostgreSQL. I looked
>>> online for some tutorials but the ones I found are out-date or only
>>> pick up after Access is connected to PostgreSQL. I was wondering if
>>> someone knew of some updated material that they could point me to or
>>> maybe walk me through it. I have used Access quite a bit years ago
>>> and things have changed since then. I know I must install the ODBC
>>> drivers, which I have already done. I have already setup the DSN and
>>> I clicked on test and it says everything is fine. I know that my next
>>> step has something to do with Linked Tables in Access, but I am not
>>> sure how to set it up. I guess that is where I start to need help.
>>> The client computers using the frontend will be running Windows 10
>>> and Office 365, both are updated to the latest versions.
>>
>> This might help:
>>
>> https://support.office.com/en-us/article/Manage-linked-tables-1d9346d6-953d-4f85-a9ce-4caec2262797
>>
>>
>>
>>>
>>> Thank you,
>>>
>>> Jason L. Amerson
>>>
>>
>>
> That will help you manage once you have created some linked tables, but
> to create them:

Which is covered in the above:

https://support.office.com/en-us/article/Manage-linked-tables-1d9346d6-953d-4f85-a9ce-4caec2262797#bkmk_add

> 
> 1) Click "External Data" from the top Access menu, then "New data
> source" on the left
> 
> 2) Pick "From other sources" at the bottom and as you correctly
> identified "ODBC Database".
> 
> 3) From the dialogue box, change the default of the two options to the
> bottom one "Link....by creating linked table"
> 
> 4) Next pick your created DSN from the "Select data source" dialog
> 
> 5) You should then see the list of tables etc from your Postgres database
> 
> Troubleshooting; make sure you have an ODBC 32 or 64 bit version
> matching the 32 or 64 bit MS Access installed.
> 
> If you use any security at the MS Access level you will need to set up a
> simultaneously shared central system.mdw file in some repository. Don't
> try to get more than 6-7 people using this at the same time, it breaks.
> 
> Good luck.
> 
> 
> --
> Tim Clarke
> IT Director
> Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
> 
> 
> 
> Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
> Web: https://www.manifest.co.uk/
> 
> 
> 
> Minerva Analytics Ltd - A Solactive Company
> 9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom
> 
> ________________________________
> 
> Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info>
> Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

  6. Re: MS Access Frontend

    Martin Mueller <martinmueller@northwestern.edu> — 2019-11-30T16:31:05Z

    Leaving aside the question of money, a frontend like AquaData Studio or the equivalent program by Jetbrains would be a much better solution. I used to work with Access a lot and quite liked it. But AquaData Studio is not any more difficult to learn and gives you access to everything Postgress can do. 

I haven't used the Jetbrains version, which is cheaper. 

On 11/30/19, 8:53 AM, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:

    On 11/30/19 3:15 AM, Tim Clarke wrote:
    > On 29/11/2019 17:30, Adrian Klaver wrote:
    >> On 11/29/19 9:23 AM, Jason L. Amerson wrote:
    >>> I am trying to setup MS Access as a frontend so that it would be
    >>> easier on my wife and children to interact with PostgreSQL. I looked
    >>> online for some tutorials but the ones I found are out-date or only
    >>> pick up after Access is connected to PostgreSQL. I was wondering if
    >>> someone knew of some updated material that they could point me to or
    >>> maybe walk me through it. I have used Access quite a bit years ago
    >>> and things have changed since then. I know I must install the ODBC
    >>> drivers, which I have already done. I have already setup the DSN and
    >>> I clicked on test and it says everything is fine. I know that my next
    >>> step has something to do with Linked Tables in Access, but I am not
    >>> sure how to set it up. I guess that is where I start to need help.
    >>> The client computers using the frontend will be running Windows 10
    >>> and Office 365, both are updated to the latest versions.
    >>
    >> This might help:
    >>
    >> https://urldefense.proofpoint.com/v2/url?u=https-3A__support.office.com_en-2Dus_article_Manage-2Dlinked-2Dtables-2D1d9346d6-2D953d-2D4f85-2Da9ce-2D4caec2262797&d=DwIC-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=q2mFiQLD3Q0WGNcvV6_A-Jva78TI-_O-TJQkuVHqU_Y&s=n5gUTTvGiefsNhxsv4WNKTOok9pQSRe9TVdcXwWPjbI&e= 
    >>
    >>
    >>
    >>>
    >>> Thank you,
    >>>
    >>> Jason L. Amerson
    >>>
    >>
    >>
    > That will help you manage once you have created some linked tables, but
    > to create them:
    
    Which is covered in the above:
    
    https://urldefense.proofpoint.com/v2/url?u=https-3A__support.office.com_en-2Dus_article_Manage-2Dlinked-2Dtables-2D1d9346d6-2D953d-2D4f85-2Da9ce-2D4caec2262797-23bkmk-5Fadd&d=DwIC-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=q2mFiQLD3Q0WGNcvV6_A-Jva78TI-_O-TJQkuVHqU_Y&s=pDhZ2CyGXAtJ2gOO7qDxiTFYvLGWbW1y-b8KRfDaK5E&e= 
    
    > 
    > 1) Click "External Data" from the top Access menu, then "New data
    > source" on the left
    > 
    > 2) Pick "From other sources" at the bottom and as you correctly
    > identified "ODBC Database".
    > 
    > 3) From the dialogue box, change the default of the two options to the
    > bottom one "Link....by creating linked table"
    > 
    > 4) Next pick your created DSN from the "Select data source" dialog
    > 
    > 5) You should then see the list of tables etc from your Postgres database
    > 
    > Troubleshooting; make sure you have an ODBC 32 or 64 bit version
    > matching the 32 or 64 bit MS Access installed.
    > 
    > If you use any security at the MS Access level you will need to set up a
    > simultaneously shared central system.mdw file in some repository. Don't
    > try to get more than 6-7 people using this at the same time, it breaks.
    > 
    > Good luck.
    > 
    > 
    > --
    > Tim Clarke
    > IT Director
    > Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
    > 
    > 
    > 
    > Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
    > Web: https://urldefense.proofpoint.com/v2/url?u=https-3A__www.manifest.co.uk_&d=DwIC-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=q2mFiQLD3Q0WGNcvV6_A-Jva78TI-_O-TJQkuVHqU_Y&s=yyQ5fbd8EgtdPmHpuM9zaCn-ZVfurKRUUMinpN3JQuI&e= 
    > 
    > 
    > 
    > Minerva Analytics Ltd - A Solactive Company
    > 9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom
    > 
    > ________________________________
    > 
    > Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info>
    > Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://urldefense.proofpoint.com/v2/url?u=https-3A__www.manifest.co.uk_legal_&d=DwIC-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=q2mFiQLD3Q0WGNcvV6_A-Jva78TI-_O-TJQkuVHqU_Y&s=Feq9uaUTpmf5lF-gisHmsk_MNn-Q0hlJ2DiZXvdXb3I&e=  for further information.
    > 
    > 
    > 
    
    
    -- 
    Adrian Klaver
    adrian.klaver@aklaver.com

  7. Re: MS Access Frontend

    Adrian Klaver <adrian.klaver@aklaver.com> — 2019-11-30T18:52:11Z

    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@aklaver.com

  8. RE: MS Access Frontend

    Jason L. Amerson <drjason@alphagenius.org> — 2019-11-30T19:04:34Z

    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.

 

Jason L. Amerson

 

 

From: Martin Gainty <mgainty@hotmail.com> 
Sent: Saturday, November 30, 2019 08:02 AM
To: Jason L. Amerson <drjason@alphagenius.org>
Subject: Re: MS Access Frontend

 

Hi Jason

this is how i got the majority of work in the 90s
I have Database X that wont talk to Database Y
you can write a program that 
parses the query from <Postgres>
accesses the data from <Access>
inserts to <Progress>

you can save time and $ if you accomplish one of these steps and contract
for the remainder

Makes Sense?
Martin

  _____  

From: Jason L. Amerson <drjason@alphagenius.org
<mailto:drjason@alphagenius.org> >
Sent: Friday, November 29, 2019 12:23 PM
To: PostgreSQL <pgsql-general@lists.postgresql.org
<mailto:pgsql-general@lists.postgresql.org> >
Subject: MS Access Frontend 

 



I am trying to setup MS Access as a frontend so that it would be easier on
my wife and children to interact with PostgreSQL. I looked online for some
tutorials but the ones I found are out-date or only pick up after Access is
connected to PostgreSQL. I was wondering if someone knew of some updated
material that they could point me to or maybe walk me through it. I have
used Access quite a bit years ago and things have changed since then. I know
I must install the ODBC drivers, which I have already done. I have already
setup the DSN and I clicked on test and it says everything is fine. I know
that my next step has something to do with Linked Tables in Access, but I am
not sure how to set it up. I guess that is where I start to need help. The
client computers using the frontend will be running Windows 10 and Office
365, both are updated to the latest versions.

 

Thank you,

 

Jason L. Amerson

  9. RE: MS Access Frontend

    Jason L. Amerson <drjason@alphagenius.org> — 2019-11-30T22:34:25Z

    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@aklaver.com> 
Sent: Saturday, November 30, 2019 01:52 PM
To: Jason L. Amerson <drjason@alphagenius.org>; 'Martin Gainty'
<mgainty@hotmail.com>; PostgreSQL <pgsql-general@lists.postgresql.org>
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@aklaver.com

  10. Re: MS Access Frontend

    Bret Stern <bret_stern@machinemanagement.com> — 2019-12-01T00:14:35Z

    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@aklaver.com>
> Sent: Saturday, November 30, 2019 01:52 PM
> To: Jason L. Amerson <drjason@alphagenius.org>; 'Martin Gainty'
> <mgainty@hotmail.com>; PostgreSQL <pgsql-general@lists.postgresql.org>
> 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@aklaver.com
> 
> 
> 
> 
>

  11. Re: MS Access Frontend

    Vincenzo Campanella <vinz65@gmail.com> — 2019-12-01T10:08:54Z

    Il 30.11.2019 19:52, Adrian Klaver ha scritto:
> 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.

What about Lazarus IDE?

https://www.lazarus-ide.org/

Free, cross platform, relatively complete and easy to use, based on 
FreePascal, with reporting tools included...

  12. Re: MS Access Frontend

    Martin Gainty <mgainty@hotmail.com> — 2019-12-01T14:09:14Z

    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
Two-phase commit protocol - Wikipedia<https://en.wikipedia.org/wiki/Two-phase_commit_protocol>
In transaction processing, databases, and computer networking, the two-phase commit protocol (2PC) is a type of atomic commitment protocol (ACP). It is a distributed algorithm that coordinates all the processes that participate in a distributed atomic transaction on whether to commit or abort (roll back) the transaction (it is a specialized type of consensus protocol).
en.wikipedia.org

Also 2 factor DB authentication was not implemented by Access
https://en.wikipedia.org/wiki/Database_security
Database security - Wikipedia<https://en.wikipedia.org/wiki/Database_security>
Database security concerns the use of a broad range of information security controls to protect databases (potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links) against compromises of their confidentiality, integrity and availability. It involves various types or categories of controls, such ...
en.wikipedia.org

Feel free to ping me offline if you're interested in implementing ODBC2JDBC driver as an option
Good Luck!

________________________________
From: bret_stern <bret_stern@machinemanagement.com>
Sent: Saturday, November 30, 2019 7:14 PM
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
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@aklaver.com>
> Sent: Saturday, November 30, 2019 01:52 PM
> To: Jason L. Amerson <drjason@alphagenius.org>; 'Martin Gainty'
> <mgainty@hotmail.com>; PostgreSQL <pgsql-general@lists.postgresql.org>
> 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@aklaver.com
>
>
>
>
>

  13. Re: MS Access Frontend

    Michael Nolan <htfoot@gmail.com> — 2019-12-01T16:46:06Z

    On Sun, Dec 1, 2019 at 8:09 AM Martin Gainty <mgainty@hotmail.com> wrote:

>
> that said I think MS missed the boat on 2-phase-commits
>

Microsoft has never really embraced the concept of a multi-user database
environment.   (It doesn't really understand the concept of a multi-user
operating system, either.)
--
Mike Nolan

  14. Re: MS Access Frontend

    Ron <ronljohnsonjr@gmail.com> — 2019-12-01T16:54:31Z

    
On 12/1/19 10:46 AM, Michael Nolan wrote:
>
>
> On Sun, Dec 1, 2019 at 8:09 AM Martin Gainty <mgainty@hotmail.com 
> <mailto:mgainty@hotmail.com>> wrote:
>
>
>     that said I think MS missed the boat on 2-phase-commits
>
>
> Microsoft has never really embraced the concept of a multi-user database 
> environment.

You haven't used SQL Server in quite a while (almost 20 years).

>   (It doesn't really understand the concept of a multi-user operating 
> system, either.)

Neither have you used Windows Server in quite a while (by my experience, 16 
years).


-- 
Angular momentum makes the world go 'round.