I would rather not have to make the users install the whole database software, just to be able to connect (remotely) through Access. If I only install the odbc-drivers, I cannot create or use a file based connection, only machine based connections. Supabase provides several options for programmatically connecting to your Postgres database: Direct connections using Postgres standard connection system.
I can set up a file based connection if I install the official driver (the 32-bit works for me), and IF I have the PostgreSQL database software installed as well. My idea was to create an Access database with linked tables to the PostgreSQL database, and to use a file based dsn connection so that the users don't have to set up their own machine connections. The Installation and Configuration Guide is suitable.
PostGreSql: ODBC Drivers for 64Bit Operating System. The amalgamation source code, the command-line shell source code, configure/make scripts for unix, and a Makefile.msc for Windows. The Simba PostgreSQL ODBC Connector is available for Microsoft Windows. We will use it as a simple interface for updating data. PostgreSQL ODBC 64 bit driver results in 'architecture mismatch' 0. I'm looking for the simplest way for Access users to connect to a PostgreSQL database.
0 kommentar(er)
