How to automate entering VBA password

VBA project password can't be considered as strong protection, but sometimes you have to use it. Unprotecting VBA Project Password article shows a sample code to unprotect project, if you know the password. Same technique can be useful when you need to interact with other programs, which you can't automate with OLE or any other interface.

Access 2016 VBA CHM file

Access 2016 VBA CHM file now made available for download (as well as Word, Excel and PowerPoint), if you need it while offline. Don't forget to unblock it (see Troubleshooting)!

ADP+ for Access 2013 with SQL Server

Another way to connect Access and SQL server - ADP+ library from Joakim Dalby, Denmark. Looks like it is build on ADO, and should work the same way as Access ADP. Would be good to know if anybody tried it?

I personally use  linked tables and DAO/pass-through tables, tried to use ADP several times, but every time switched back to mdb.