AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Monday, November 30, 2015

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.

AzlJ6

Labels:

Wednesday, November 18, 2015

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

Labels:

Thursday, November 12, 2015

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.

Labels: ,