How to check if database is locked from VB Outlook

[bearsgone]

Hello


I have a custom form that imports data from a form in Outlook into Access database.

Does anybody have an example of code that will check if database is locked. If database is locked, data from the form can not be imported and user should be notified. Is there an error code for it, like there is a code 53 if database file is missing?

Thank you for any help

[llkhoutx]

Try to attach the database and trap the error (I don't know the code), if it won't attach, otherwise it's available.