bclothier

About Ben Clothier

This author has not yet filled in any details.
So far Ben Clothier has created 65 blog entries.

Opening or Linking Text or Excel as Data Sources in Microsoft Access

Opening or Linking Text or Excel as Data Sources in Microsoft Access   Access is a phenomenal tool for working with many data sources. You may have long known that you can easily import or export data in a wide array of formats. However, we had a scenario where we needed to process data from ex [...]

2021-06-11T04:52:20-05:00October 19th, 2020|

[UPDATED 2] Critical: Office Update breaks Access — Query is corrupt

We've gotten reports from our clients, our colleagues and other posters that there is a huge problem with the Office 365 update that was released yesterday (November 12, 2019). The update causes an error where it may say: "Query "" is corrupt" This post deals with both preventive and restorative mea [...]

2021-06-10T10:40:40-05:00November 13th, 2019|

Using OASIS-SVN and git for Access source code control

NOTE: I will be talking about this topic in depth in the upcoming Access and SQL Server monthly webinar on July 9th at 6:30 PM CDT. Register so that you can view the process live and ask questions!   As we work with several applications and sometime in a team, source code control is pretty impo [...]

2022-01-07T09:04:42-06:00July 2nd, 2019|

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

2021-06-11T05:47:43-05:00September 11th, 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 [...]

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

Using Large Parameters for Microsoft SQL stored Procedure with DAO

Using Large Parameters for Microsoft SQL stored Procedure with DAO As many of you already know, SQL Server team has announced deprecation of OLEDB for SQL Server database engine (Read: we can't use ADO because ADO uses OLEDB). Additionally, SQL Azure does not officially support ADO, though one still [...]

2022-06-10T13:12:59-05:00June 22nd, 2017|

Reporting More Granularly Than Usual – Microsoft Access

Reporting More Granularly Than Usual - Microsoft Access Typically, when we do reporting, we usually do it at a higher granularity. For example, clients commonly wants a monthly report of sales. The database would store the individual sales as a single record, so it's no problem summing up the figure [...]

2022-07-26T03:33:47-05:00September 29th, 2015|

7 Ways To Do Sequential Numbering in Microsoft Access

7 Ways To Do Sequential Numbering in Microsoft Access Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In oth [...]

2022-01-07T08:50:41-06:00July 28th, 2015|

Working With Console Tools – Microsoft Access

Working With Console Tools - Microsoft Access We recently had a project that required us to interact with console tools. People might have different terms for those type of tools so when I speak of console tools, I'm referring to a program or script that opens a command prompt and output stuff to th [...]

2021-06-11T07:45:07-05:00June 16th, 2015|
Go to Top