Hi,
i would like to ask if it's possible to use Jackcess on a MDB File which is also used by a Access form outside from Jackcess.
We would write and read data into the MDB when exactly on the same time other users use Access forms to write and read data.
Is this safe or can it destroy the Data?
And what is the best practice with this problem?
PS: The case that the MDB is read and written per Access forms can't be changed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Mhh ok.
Whats the correct impact of that error?
Will it create invalid data or does it destroy the complete file?
Is it only when write in the same table or doesn't it care at all?
And are there possibilities to read the locking/working file of Access to see where it will be write/read or to get just information for that problem?
And what is the best practice to avoid the destroying of the data or file in my case? Is it even possible with Jackcess?
And thanks for the quick answer.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
i would like to ask if it's possible to use Jackcess on a MDB File which is also used by a Access form outside from Jackcess.
We would write and read data into the MDB when exactly on the same time other users use Access forms to write and read data.
Is this safe or can it destroy the Data?
And what is the best practice with this problem?
PS: The case that the MDB is read and written per Access forms can't be changed.
You are correct, that would destroy the access database. Jackcess does not implement any form of database locking, which you would need in order to make that work successfully. https://sourceforge.net/p/jackcess/discussion/456474/thread/84de77ea/
Mhh ok.
Whats the correct impact of that error?
Will it create invalid data or does it destroy the complete file?
Is it only when write in the same table or doesn't it care at all?
And are there possibilities to read the locking/working file of Access to see where it will be write/read or to get just information for that problem?
And what is the best practice to avoid the destroying of the data or file in my case? Is it even possible with Jackcess?
And thanks for the quick answer.
it doesn't matter which table you are modifying, there are lots of shared resources in the access database. most likely result is corrupted db.
i believe it is possible to do shared updates since i believe microsoft implements it with their products, but i have no idea how it is implemented.
the best practice for avoiding the problem is that jackcess needs exclusive ownership of the file in order to work with it.