My Java program connects to a database created by MS Access. It reads the database tables and during the course of a mission adds records to tables and also updates records. There are other applications that also use the database, mostly reading what I have written in it.
We have found that when I have the database open via UCanAccess, et.al. the other programs (not Java/UCanAccess) do not have complete ability to read from the database. They are able to open and read the tables initially but cannot refresh. My program adds records and updates fields but the others cannot refresh their view of the table. This is even true for Access itself. If we close the other app and reopen it, the changes are now visible. So we know that the data is being written but the readers can't see it.
Have you seen this kind of problem before? Do you have a suggestion for how to fix it?
Thanks,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
My Java program connects to a database created by MS Access. It reads the database tables and during the course of a mission adds records to tables and also updates records. There are other applications that also use the database, mostly reading what I have written in it.
We have found that when I have the database open via UCanAccess, et.al. the other programs (not Java/UCanAccess) do not have complete ability to read from the database. They are able to open and read the tables initially but cannot refresh. My program adds records and updates fields but the others cannot refresh their view of the table. This is even true for Access itself. If we close the other app and reopen it, the changes are now visible. So we know that the data is being written but the readers can't see it.
Have you seen this kind of problem before? Do you have a suggestion for how to fix it?
Thanks,
Yes, it's a known Access behaviour. Here's a clear explanation by Gord: https://sourceforge.net/p/ucanaccess/discussion/help/thread/9fd6f244/