VB 6.0 Access Database

[Alawaththa]

Hi,i have an .exe(don't have codes) which connect with ms-Access database.When executing the .exe the Access database will Exclusively lock.
But i need to read data from database by using VB 6 Application while running above .exe
Pls Help.
Alawaththa.

[debasisdas]

If you know that the entire database is exclusively locked, how can you access that .

[Alawaththa]

Is there any mechanism to unlock or allow read only lock when another .exe puting exclusive lock on the database

[Killer42]

Is there any mechanism to unlock or allow read only lock when another .exe puting exclusive lock on the database

Try setting the read-only attribute on the MDB file before running the program, to see what happens. (It might prevent the program working, of course).

[Alawaththa]

I did it ,but when .exe runing read only lock automatically disabled.

[Killer42]

I did it ,but when .exe runing read only lock automatically disabled.

What, it actually turns off the read-only attribute? Well... um... what about if you open the MDB file (in MS Access, perhaps) before running the program. That way it cannot open the database exclusively. It will have to either open it for shared use, or fail to open it at all.

[Killer42]

Thanks for that, ilasabba. Alawaththa, please let us know whether this helps.

[Alawaththa]

thanks all got the point.