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

About Me Search
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.



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


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: ,

Tuesday, October 13, 2015

Access UserVoice

Access on UserVoice  - suggest ideas and vote for others feedback. Access team promised to monitor this site :)


Tuesday, September 22, 2015

What's new in Access 2016

Here are some of the top new features you'll find in Access 2016


Thursday, September 17, 2015

Access Lunchtime user group

Access MVPs Juan and Ben staring "Lunchtime" online Access user group at September 29th, mark your calendars and join it last Tuesday of the month at 12 noon CDT!

Details are here Access Lunchtime


Wednesday, September 16, 2015

Known issues with Office and Windows 10

Following article is a list of known issues with Office and Windows 10, planned to be kept up-to-date:

Known issues with Office and Windows 10