Go to Top

Uncategorized

Join me at SQL Saturday Dallas on May 18th, 2018

I’ll be presenting my hugely popular “Wish you could live the glamorous consulting life?” first thing in the morning that day, plus I’ll have a table where I’ll be answering questions on SQL Server optimization with Access, if you are in the Dallas area please consider attending this great one day event! You can register here: https://www.sqlsaturday.com/734/RegisterNow.aspx  What is SQL Saturday? SQLSaturdays are free 1-day training events for SQL Server professionals, …Read More

Why I’m optimistic about the future of Access

I’m just back from the recent PAUG conference where I had the chance to meet some of the best minds in Microsoft Access, it’s only one of two conferences worldwide, (Access DevCon Vienna is the other one), and it showcased some great content over a three day period. This year’s conference had quite a few new attendees, fresh blood that will take up the Access mantle for years to come. We …Read More

Getting “System Resource Exceeded” messages? Here’s one way to fix it

System Resource Exceeded Error Message Lately we’ve been seeing a barrage of clients getting “System Resource Exceeded”  when migrating to Windows 10, even though the system worked fine in prior versions of Windows. In some cases we’ve traced the issue to apps that use a lot of subforms in a tab control, so I’m going to describe a technique that will prevent the issue in those cases when each tab …Read More

**BREAKING NEWS** NEW SQL SERVER NATIVE CLIENT 18 released!

As promised, the new SQL Server Native Client 18 is now available to download. Either Ben Clothier or I will be testing Azure authentication and other aspects of ADODB and be providing feedback soon! In the meantime, check out the announcement and other documents below : Announcement: bit.ly/SNC18 OLEDB Driver Info: bit.ly/OLEDB18 ADODB Info with Native Client 18: bit.ly/ADODB18 Download Native Client 18 Here: bit.ly/SNC18Down

Help us get the IDE modernized in Access, your vote counts!

After my Access with SQL Server meeting were we talked about using User Voice to prompt change to our beloved IDE, I found out that the Access team does not have any sway over the environment, it’s handled by the another group in the Office hierarchy. I’ve since endorsed the following ideas on User Voice and request that you lend your support as well! Note: PLEASE leave a comment on …Read More

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

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