Home Forums Microsoft Access Microsoft Access How to avoid opening a password-protected mdb RE: How to avoid opening a password-protected mdb

  • October 25, 2013 at 5:21 am

    #1661578

    Before opening the database with "app.OpenCurrentDatabase" you could first try to connect with an OLEDB connection. The OLEDB connection doesn't use a GUI so you can easily handle an error in the code. If the connection succeeds you can open the database, if the connection fails you should skip it.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **