Skip to content

[tip] use ExtendedAnsiSQL

Jump to bottom
Gord Thompson edited this page Sep 30, 2024 · 3 revisions

To support DECIMAL(m, n) columns in Access, enable ExtendedAnsiSQL in your DSN (or connection string) by setting its value to 1. In the ODBC Administrator utility the setting is available via the "Advanced…" button on the main configuration dialog:

Advanced Options dialog

Clone this wiki locally