Hy
sometimes appens that our customer open MDB file with access and open also a table while our function is write records.
Now using AccessJBDC if I open table while my program is writing records at the end the table is corrupted. Is there any solution ? Of Course I know the MDB should not be open....
Thks.
|
Hy
what's the meaning for error
"Failed to insert a new record into table COLLIASS:A corrupted data page 744" =
I solved opening the MDB and using ACCESS function REPAIR.
This happens while two programs wsa writing on the same MDB, but different tables.
Thks
|
"This happens while two programs was writing on the same MDB, but different tables"
I checked better when two programs write on same MDB at the sametime the MDB gets corrupted.
Maybe there is an option for this ?
Thks
|
|
You should use lockType=ACCESS connection property for concurrent data modification.
|
Yes thks....I read online docs and I'm trying.
Thks a lot.
|
Main
webmaster@hxtt.com