Hello,
I have an application in which the users have a local front-end (FE) Access database (in runtime) that connects over the company network to a back-end(BE) database.
The BE is saved on a (file-) server in accdr form.
While this is no good protection for a database it should be sufficient as none of the users with network-access to the location know how to change the extension and open the file.
The accdr is only there to show the users a blank screen in the event of an accidential double-click.
The Problem:
I was using the database as a normal user.
It seems that the network connection briefly dropped.
So I ended up with a corrupted record.
I would like to change the extension of the accdr to accdb, fix the record and rename to accdr.
The problem is it still has a record locking file and windows claims the accdr file is in use (Which also prevents any kind of deletions).
The Question:
How can I terminate all connection to the BE accdr?
Or is there a way to force windows to clsoe all connections, allowing me to delete or rename the file?
I have an application in which the users have a local front-end (FE) Access database (in runtime) that connects over the company network to a back-end(BE) database.
The BE is saved on a (file-) server in accdr form.
While this is no good protection for a database it should be sufficient as none of the users with network-access to the location know how to change the extension and open the file.
The accdr is only there to show the users a blank screen in the event of an accidential double-click.
The Problem:
I was using the database as a normal user.
It seems that the network connection briefly dropped.
So I ended up with a corrupted record.
I would like to change the extension of the accdr to accdb, fix the record and rename to accdr.
The problem is it still has a record locking file and windows claims the accdr file is in use (Which also prevents any kind of deletions).
The Question:
How can I terminate all connection to the BE accdr?
Or is there a way to force windows to clsoe all connections, allowing me to delete or rename the file?
