Using SQL Views to Add/Edit Data in Microsoft Access This is part II of a two part series on views I've written, you can see part I here. Over the last couple of years I have had a great deal of experience with working on Access Databases with the Data is linked to tables in stored in SQL Server. Wi [...]
Detangling the New Microsoft SQL Server ODBC and OLEDB Drivers Some of you may already know that Microsoft backtracked on their planned deprecation of OLEDB and provided a new OLEDB driver. However, it can be a head-scratcher to figure what you should be using. When we were using SQL Server Native C [...]
Join Me For a Microsoft Access with SQL Server Academy Session We kick off the new season of Access with SQL Server group meetings this year with three months of training: Introduction, Intermediate and Advanced topics on how to optimize Access with SQL Server. Part 1: Introduction On Tuesday Septem [...]
Pitfalls to Avoid When Using the New Microsoft SSMA Version 7.8 Microsoft has been updating their SQL Server Management Assistants on a regular basis, and they just updated the SSMA for Access. However you can't see what's new for 7.8 in their official documentation. The latest version of SQL Server [...]
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 [...]
Designing a Microsoft T-SQL Trigger On occasions when building a project involving an Access front-end and a SQL Server backend, we've run into this question. Should we use a trigger for something? Designing a SQL Server trigger for Access application may be a solution but only after careful conside [...]
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 [...]
