Updating your SQL Drivers can be a pain, unless you do this

It seams Microsoft is releasing new drivers every few months now, trying to keep pace with the trove of new SQL Server and Azure features that come out with every new version. The drivers do double work, both with the product you can install locally, and the Azure service in the cloud. Why you shoul [...]

2022-12-04T11:59:26-06:00December 4th, 2022|

No meeting tomorrow, join me on December 13th

I am currently traveling through the Middle East on a entrepreneurship training course through Israel where I’m meeting startups and getting a ton of ideas for my practice. Consequently we will not be having our normal meeting in November and our next meeting is in December 13th 2022. Here are the m [...]

2022-11-07T10:39:02-06:00November 6th, 2022|

How I bombed at my last presentation – yes, it happens to all of us

Last Tuesday, October 11, 2021 I was all set to present SQL Server with Access Academy Part II when I hit a roadblock I could not overcome: SQL Server Migration Assistant for Access, (SSMA), would not load the sample Northwind database and I was stuck, could not continue the session. I've done it fo [...]

2022-10-26T16:05:33-05:00October 26th, 2022|

Azure mandating TLS 1.2 may break dependent .NET libraries

We got a pleasant surprise when one of our clients reported to us that the application was no longer. In this case, it had a .NET DLL that called Azure service. The code was very straightforward; just reference a nuget package provided by Microsoft and call methods on it and it just works™. Few mont [...]

2022-08-05T09:16:52-05:00August 5th, 2022|

ALERT: Office Version 2204 may break Access applications

As a FYI, Microsoft has issued another update to current channel (Build 2204) which apparently contained changes that causes the otherwise functional Access application to stop work and throw errors. You may see the following error messages: * Property not found * No current record. * The search key [...]

2022-05-11T16:05:55-05:00May 11th, 2022|

Identifying and Managing Mission-Critical Access Applications During a Development Project

During your Access development project, it is important that you identify mission-critical Access applications. These are the Access databases that are crucial to the success of your project and your business as a whole. If these applications are not functioning properly and you have no idea how to [...]

2022-05-20T05:14:37-05:00May 6th, 2022|

6 Reasons Microsoft Access Can Help Your Business

Almost every business in the world uses Microsoft Excel. For creating simple spreadsheets, it’s probably the best piece of software in the world. But as a company grows and spreadsheets become more complicated, Excel will show its limitations. This is where Microsoft Access comes in. When your comp [...]

2022-04-19T03:46:49-05:00March 24th, 2022|

New Drivers For SQL Server… What You Need to Know

Recently, Microsoft released two new drivers for SQL Server, a major upgrade: ODBC 18 Driver for SQL Server OLEDB 19 Driver for SQL Server That's great news! However, there is a major breaking changes that requires your attention. Specifically, they changed how the default settings work for the encr [...]

2022-03-08T07:46:52-06:00March 7th, 2022|
Go to Top