Updates From the Microsoft Access Team (June 2017) New data connectors Announcement blog post on the Access blog. It has also been twitted here - feel free to retweet it! New in Microsoft Access: Microsoft Dynamics and Salesforce connectors. Learn more: https://t.co/NesijpM5uG — MS Office News (@Off [...]
Drag and Drop In MS Access and Conditional Sorting Drag and Drop In MS Access Doug was on a roll in January of 2004 when he wrote his article on drag and drop in MS Access. He tested it now using Access 2016 and it still works. This article shows you how to add drag-and-drop to your Access applicati [...]
Official Microsoft Access Tech Blog is Now Online! Official Microsoft Access Tech Blog Launches! In addition to the blog on the Office site, the Access team has started a technical blog here. The new Access Tech Blog will be more technical in nature and oriented towards technical users instead of re [...]
Using Large Parameters for Microsoft SQL stored Procedure with DAO As many of you already know, SQL Server team has announced deprecation of OLEDB for SQL Server database engine (Read: we can't use ADO because ADO uses OLEDB). Additionally, SQL Azure does not officially support ADO, though one still [...]
Learn How to Spawn Forms in Memory (Yes, You Heard That Right) Hi Everyone! This Tuesday I’m going to demo an amazing concept: How to spawn multiple copies of the same form in memory. Have you ever wanted to display multiple orders or invoices in your databases in separate forms using the same form [...]
MayBeSQL Coming to Microsoft Access! In a stunning development, Microsoft Access will debut a new version of SQL called MayBeSQL, in response to the market clamoring for more NoSQL solutions. Originally, NoSQL meant "No SQL" but in more recent iterations, has come to mean "Not Only SQL". The change [...]
Exclusive! Join us With Our Guest Michal Bar, Access Program Manager Exclusive! Join us on Tuesday March 14th at 6.30pm CST with our guest Michal Bar, Microsoft Access Program Manager at Microsoft! Learn about the future of Access, see demos on new features the Access team has worked on and get answ [...]
Microsoft Access DevCon in Vienna Austria April 1st - 2nd, 2017 This year Access MVP Karl Donaubauer has invited me to speak at his first Access DevCon in Vienna on April 1st and 2nd 2017. Karl has many years of producing similar events in German but this time around it's in English and I'm really e [...]
Unanswered Questions About MS SQL Server Security and Access Control For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude [...]
Ten Ways Your Data Project is Going to Fail Data science continues to generate excitement and yet real-world results can often disappoint business stakeholders. How can we mitigate risk and ensure results match expectations? For more information go here. [...]
If you Could Ask the MS Access Team Any Question, What Would it Be? Next month Ben and I are once again traveling to the MVP Summit at Microsoft headquarters for our annual pilgrimage to the mothership. It's a wonderful affair were we get wined and dined and fawned over by Microsoft, and of course m [...]