Protect MS Access file from other applications when i'm accessing it.

Thread view:

Dhanan - 26 May 2004 17:34 GMT

Hi,

Is there a way to protect my MS Access database file from other
applications when i am using it through jdbc - odbc bridge

I call DriverManager.getConnection ...
after that no other application shall access / copy the mdb file until
i call connection.close();

Is it possible?
Any advice is highly appreciated?

Thanks in advance,

Regards,
Dhanan

driver: sun.jdbc.odbc.JdbcOdbcDriver
url: jdbc:odbc:DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=Z:\\db1.mdb;

Reply to this Message

Davis - 31 May 2004 17:16 GMT

> Hi,
>
[quoted text clipped - 16 lines]
> url: jdbc:odbc:DRIVER={Microsoft Access Driver
> (*.mdb)};DBQ=Z:\\db1.mdb;

If you are going through the jdbc-odbc bridge that means you can
directly see the mdb file on the file system. You should therefore be
able to create a File object on the physical file and use the
setReadOnly method while you are working on it. I have never tried it
and don't know if it would work but it looks possible.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...