With acknowledgement for at least one
prior discussion on this topic, I am still unable to set up an ODBC link that will allow me to use MS Access to edit non-spatial attributes of an existing record in a Geopackage database created with qGIS.
Here is the DNS that I'm using:
DSN=SQLite3 Datasource;Database=C:\Dropbox\GIS Data\Improvements\Improvements test gpkg\Improvements gpkg.gpkg;StepAPI=0;SyncPragma=NORMAL;NoTXN=0;Timeout=100000;ShortNames=0;LongNames=0;NoCreat=0;NoWCHAR=0;FKSupport=0;JournalMode=;OEMCP=0;LoadExt='C:\Program Files\QGIS 3.20.0\bin\mod_spatialite.dll';ACCDB=YES;
And when I try to edit an attribute in an existing record, a popup informs me :
"ODBC update on linked table '"Improvements gpkg' failed.
No such function: ST_IsEmpty(1) (#1)
Any and all comments / suggestions are welcome!