Go to Top

Blog Archives

It’s time we gave the Access IDE some love

Quick: when  was the last time the Access Integrated Development Enviroment  (IDE) got a new feature? I can’t remember. While Access in general has gotten love from the Access team, in particular the new data connectors, its time we add SOME kind of new feature to the IDE, but which one?: Collapse procedures? Improved Searching? Intellisense for tables? This month I’ll be discussing these ideas and more at our regular …Read More

Inspect the control source of all controls in your project

Happy New Year! Recently I was working on a project where I was implementing form spawning so that my client can see at least two different records using two identical forms, one of the actual forms and the other one a spawned version of itself, (a topic I’ve discussed at my SQL Server with Access meetings, click to join the announcement list!). Because the prior developer did not use form …Read More

OLE DB Undeprecated! Long live ADO!

The Microsoft SQLNCli team has undeprecated OLE DB and the news could very well be earth shattering for the Microsoft Access community. Previously deprecated and last supported with SQL Client 11, OLE DB was on it’s last breaths, and what was worse, we could not come up with a equivalent solution using DAO and pass through queries for all the features we had with OLE DB. Thankfully the team in …Read More

Our Microsoft Ignite session recording is now available to view!

Hello everyone! I just got back from Microsoft Ignite, where Michal Bar and I had a wonderful time presenting on “Learn new ways to apply Access to the modern Microsoft ecosystem”. We discussed a few great topics, one of which is how to consume Azure services with Access. We should have the sample application on the Microsoft Technical Blog soon, in the mean time you can see our presentation in …Read More

Meet Michal Bar and me at Microsoft Ignite!

This week Microsoft has invited me to speak at Microsoft Ignite along with Michal Bar from the Microsoft Access team! I’ll be in Orlando all week learning about new technologies and on Wednesday afternoon present on how to plug Access into the modern Microsoft echo system in a 75 mins session.  If you’re going to Microsoft Ignite please consider coming to my session or even meeting at the Office booth during …Read More

Official Access tech blog now online! Also, more improvements to Access!

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 regular ones on the office blog. Accessibility Updates in Access The very first post on the new blog from the Access team has been hard at work on …Read More

Tuesday April 11th: 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 design? One way of doing this would be to have multiple copies of the same form in your system, for example: frmOrder, frmOrder1, frmOrder2, etc. But the problem …Read More

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 is sure to position Access to compete with MongoDB or DocumentDB! Since it’s inception, Microsoft Access has been structured as a RDMS using a subset of …Read More

Exclusive! Join us March 14th our guest will be 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 answers to the pressing questions of our beloved Access program. Is Access going away? Is VBA going away? What computer language is Access built on? What new features has the Access team working …Read More

Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.