pg.ddx.io  GitHub: postgresql-interfaces/psqlodbc (issues + PRs as email threads)  
help / color / mirror / Atom feed
From: valentinguenon (@valentinguenon) <noreply+valentinguenon@github.com>
To: postgresql-interfaces/psqlodbc <noreply+postgresql-interfaces-psqlodbc@github.com>
Subject: [postgresql-interfaces/psqlodbc] issue #240: Access 365 linked PostgreSQL tables do not show checkbox filter value lists
Date: Tue, 10 Nov 2026 15:19:24 +0000
Message-ID: <gh-postgresql-interfaces-psqlodbc-240@github.com> (raw)

Hello,

I am using Microsoft Access 365 (Version 2609, Build 16.0.20430.20032, 32-bit) with psqlODBC 18.00.00.02 and PostgreSQL linked tables.

I have encountered an issue with the filter menus in Access.

Environment
Microsoft Access 365 (32-bit)
Version 2609, Build 16.0.20430.20032
psqlODBC 18.00.00.02
PostgreSQL linked tables via ODBC
Unicode and ANSI drivers tested
Observed behavior

When opening a linked PostgreSQL table in Datasheet View and clicking the filter dropdown on a text field, Access only displays:

Sort A to Z
Sort Z to A
Text Filters

The usual list of distinct values with checkboxes is not displayed.

Additional information
The tables have valid primary keys.
Access correctly recognizes the primary keys.
The linked tables are fully editable (insert, update, delete).
The issue occurs on all client workstations.
The issue appeared immediately after migrating from local Access tables to PostgreSQL.
Re-attaching the tables does not change the behavior.
Creating simple queries such as:
SQL
SELECT TOP 100 *
FROM T_Mouvements;

does not restore the checkbox filter list.

The same filter works correctly on local Access tables.
ODBC settings
Recognize Unique Indexes = Enabled
Use Declare/Fetch = Disabled
Question

Is the absence of the Access checkbox filter value list on PostgreSQL linked tables a known limitation of psqlODBC, or should Access normally be able to retrieve the distinct values required for these filter menus?

Has anyone successfully obtained the standard Access checkbox filter lists on PostgreSQL linked tables?

Thank you for your help.

Best regards,

Valentin Guenon

Message-ID: <gh-postgresql-interfaces-psqlodbc-240@github.com>
Permalink:  ../gh-postgresql-interfaces-psqlodbc-240@github.com/

 · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox