From very painful experience linking access to cache can be a very difficult proposition. In theory it's simple, an odbc link from access can read data fine from cache. However if you want to write anything back or perform updates of any kind it gets very finicky.
We ended up writing sql stored procedures in cache and calling them from access for any data modifications. So the linked odbc tables were only used for read only access.
Also be aware of large integer numbers, which need the bigint data type in access to display properly, which was only introduced in access 2019.
- Log in to post comments