copy access file still locked
Posted on 2013-05-16
hey guys, i'm putting an access file on a network where it will be accessed by many people at the same time. i've used a force shutdown mechanism BUT in the event that something screws up and the network access file always has an .ldb file, are there any problems if i just copy the mdb file to my desktop, delete both the .mdb and .ldb file from the network and then just compact and repair the mdb file on my desktop before putting it on the network?
what i think is that i'll lose some data on the ldb file but it's ok in this case that i lose that data. i'm just trying to find a way to reset the database should it become corrupted.