Re: MS Access Frontend

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