Check if a back end is (still) password protected

[Ronald]

Hi.

What is the best way to check if a back end database is (still) password
protected?

The only way I can think of is:
Try to link a table without the password. Then catch the error and link
again with the password.
So if no error occurs the back end is not password protected.
What is your solution?

Thanks,

Ronald.

 

[Alex Dybenko]

Hi,
you can also try to open db using OpenDatabase method without password and
check for error

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Daniel Pineault]

That is the method I use and it was suggested to me originally by one of the
MVPs, so I'm pretty sure that is the best method to use.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.