Check if password has been modified in current Access database when opened exclusive

Check if password has been modified in current Access database when opened exclusive



For security reasons, I have been trying to find a way of checking if the password has been removed or modified in the current Access database. This is just one part of a series of routines designed to prevent hacking



This has proved more complex than expected and I'm probably missing something obvious.



I couldn't work out a method of checking the password in the current db



What I did instead is as follows:



Open the database and create a copy using file scrpting object code.
This prevents error 70 - file permission denied.



Still in the current db, attempt to open the copy using code without a password.



If that succeeds, the password has been removed from the original.
If that fails, repeat using the correct password.
If that also fails, the password has been modified



Kill the copy created.



If the password has been removed/modified the application then quits



All of that works fine UNLESS the app is opened exclusive.



However, if opened using /excl switch, error 70 (permission denied) occurs at step 1.



Why? No error occurs if opened normally



Is there a workround?



Or better still, is there any code that can check the password of the current database once it has been opened









By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Help:Category

How can temperature be calculated given relative humidity and dew point?

I have a recursive function to validate tree graph and need a return condition