Brian Samuelson - 2021-07-16

I'm using UCanAccess 5.0.0 with Lucee 5.3.3.62. Everything seems to be running well, for the most part, however I'm running into an issue in my test environment where if I add a record to a table and then overwrite the MDB file with a clean file, UCanAccess still pulls up the added record.

I can fix this by either opening the MDB file in Access or by restarting Lucee. This is somewhat manageable in a dev environment, but Access is not running on the server, and restarting all sites when one site needs to update their list of agents is a painful option.

Is there any way to force UCanAccess to either reload the data or reload itself? Or, a setting to tell it to always pull from source? Or, some other option?