Alex & Access

November 30, 2015

How to automate entering VBA password

Filed under: VBA — access @ 11:56 am

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.

AzlJ6

November 18, 2015

Access 2016 VBA CHM file

Filed under: Access 2016 — access @ 10:32 am

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)!

November 12, 2015

ADP+ for Access 2013 with SQL Server

Filed under: Access, SQL Server — access @ 12:13 pm

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.

Create a free website or blog at WordPress.com.