Go to Top


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

See you at the 2018 PAUG Conference

On Sunday – April 29, 2018 -, between 1:00 PM and 2:00 PM, I will be speaking at the annual PAUG Conference. Registration is open. Register now! Hurry, seats are limited & quickly sell out! This year promises to be the best! The dates for the PAUG 2018 Database Designer International Conference are set: April 28 (Saturday, 12 PM) – April 30 (Monday, 3 PM). We will be returning to the Conference Center at Silver Falls. …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

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

Using large parameters for 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 can get away with it using SQL Server Native Client. However, the new 13.1 ODBC driver comes with a number of features that won’t be available in the SQL Server Native …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

Access DevCon in Vienna Austria April 1st to 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 excited about the great lineup and chance to visit Vienna for the first time! For more information and to register, please visit http://www.donkarl.com/devcon/agenda.htm Let me know …Read More

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