Detangling the New Microsoft SQL Server ODBC and OLEDB Drivers

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 [...]

Ben Clothier2021-06-11T05:47:43-05:00September 11th, 2018|

Join Me For a Microsoft Access with SQL Server Academy Session

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 [...]

Juan Soto2021-06-11T05:48:32-05:00September 9th, 2018|

Pitfalls to Avoid When Using the New Microsoft SSMA Version 7.8

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 [...]

IT Impact2021-06-11T05:49:24-05:00July 3rd, 2018|

Text or Numeric Field – A Simple SQL Method to Switch Data Type

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 [...]

Susan Pyne2021-06-11T06:10:54-05:00June 26th, 2018|

Designing a Microsoft T-SQL Trigger

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 [...]

Ben Clothier2021-12-19T23:18:56-06:00June 19th, 2018|

Microsoft SQL Server – Join Me at SQL Saturday Dallas

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 [...]

Juan Soto2021-06-11T06:12:25-05:00May 12th, 2018|

Reasons to be Optimistic About the Future of Microsoft Access

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 [...]

Juan Soto2021-11-23T07:42:05-06:00May 7th, 2018|

How to Fix ‘System Resource Exceeded’ When Migrating to Windows 10
How to Fix ‘System Resource Exceeded’ When Migrating to Windows 10

VBA, Access Help, Uncategorized

How to Fix ‘System Resource Exceeded’ When Migrating to Windows 10

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' [...]

Juan Soto2021-06-11T06:14:18-05:00April 22nd, 2018|

BREAKING NEWS: New Microsoft SQL Server Native Client 18 Released!

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 [...]

Juan Soto2021-06-11T06:15:09-05:00April 8th, 2018|

Help us Get The IDE Modernized in MS Access – Your Vote Counts!

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 [...]

Juan Soto2021-06-11T06:16:25-05:00April 8th, 2018|

It’s Time We Gave the Microsoft Access IDE Some Love

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 [...]

Juan Soto2021-11-23T07:39:09-06:00February 4th, 2018|

Blog