Firstly ucanaccess has been a great library for my project.
I have one annoyance that if a user has a table open when I execute update from my java program sometimes it causes corruption in the database (not to mention changed are not updated until you reopen database)
I assume the only way around this is to check progamtically if Access is running and prompt the user to close it?
Cheers
-Al
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
Firstly ucanaccess has been a great library for my project.
I have one annoyance that if a user has a table open when I execute update from my java program sometimes it causes corruption in the database (not to mention changed are not updated until you reopen database)
I assume the only way around this is to check progamtically if Access is running and prompt the user to close it?
Cheers
-Al
-Use Openexclusive=true connection parameter to avoid access from multiple processes(you can still use a multithread access).
-Changes are updated when you commit you updates, but Ms Access doesn't know it.
See here to solve:
https://sourceforge.net/p/ucanaccess/discussion/help/thread/d30cb214/
https://sourceforge.net/p/ucanaccess/discussion/help/thread/9fd6f244/#57dd/6b28