Text or Numeric Field – A Simple SQL Method to Switch Data Type I recently worked on a project where our client is selling a product throughout the USA built on Access with SQL Server, it works by importing data into SQL and then analyzing it with Access reports. Unfortunately each customer may have [...]
Microsoft SQL Server - Join Me at SQL Saturday Dallas 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 Dall [...]
Reasons to be Optimistic About the Future of Microsoft 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 cont [...]
How to Fix 'System Resource Exceeded' When Migrating to Windows 10 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' [...]
BREAKING NEWS: New Microsoft 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 an [...]
Help us Get The IDE Modernized in MS 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 Of [...]
It’s Time We Gave the Microsoft 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 [...]
Inspect the Control Source of All Controls in Your MS Access 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 vers [...]
Join Me at the PAUG Database Designer 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 [...]
Microsoft 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 c [...]
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 [...]
