fbpx

About Ben Clothier

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

UPDATED: Bug Causes Microsoft Office 365 Build 2105 Breaks Access Applications

Bug Causes Microsoft Office 365 Build 2105 Breaks Access Applications   UPDATE: The bug may be due to the vbWatchDog crashing on 64-bit builds. We initially reported that this was an issue affecting the 2105 build in general. However, further findings and additional reporting has indicated that [...]

UPDATED: Bug Causes Microsoft Office 365 Build 2105 Breaks Access Applications2021-06-11T04:18:22-05:00

Writing Readable Code for VBA – Try* pattern

Writing Readable Code for VBA - Try* pattern   Lately, I've been finding myself using the Try pattern more and more. I really like this pattern because it makes for much more readable code. This is especially important when programming in a mature programming language like VBA where the error h [...]

Writing Readable Code for VBA – Try* pattern2021-06-11T04:36:17-05:00

Ad-hoc Connection Strings and Heterogeneous Queries for MS Access

Ad-hoc Connection Strings and Heterogeneous Queries for MS Access   Heterogeneous queries is the reason why connection strings, especially ad-hoc connection string are important. In previous articles of the series, you saw how you could customize the connection parameters for connecting to Exce [...]

Ad-hoc Connection Strings and Heterogeneous Queries for MS Access2021-06-11T04:39:52-05:00

Connection String Parameters for Saved Specifications

Connection String Parameters for Saved Specifications   Access provides a second method of describing text files' schema by using system tables MSysIMEXSpecs and MSysIMEXColumns to save the specifications. In the previous article, I covered how schema.ini can be used to describe a text file's s [...]

Connection String Parameters for Saved Specifications2021-06-11T04:41:10-05:00

Connection String Parameters for Schema.ini

Connection String Parameters for Schema.ini   Making a schema.ini to open or link text files from Access is one of two possible methods that can be used to work with data contained in the files from Access. In the previous article, we looked at the text file's connection string parameters. We a [...]

Connection String Parameters for Schema.ini2021-06-11T04:43:50-05:00

Connection String Parameters for Text File Sources

Connection String Parameters for Text File Sources   In the previous article I covered the connection string parameters for Excel data sources. We will now focus on the text files. There are different methods for describing text files' schema and using the information during opening or linking [...]

Connection String Parameters for Text File Sources2021-06-11T04:47:21-05:00

Connection String Parameters for Excel Data Sources

Connection String Parameters for Excel Data Sources   In the previous article, I discussed how we can treat Excel and text files as if they were a database using DAO, and how we can open them without linking. Because they do not use ODBC drivers, their connection string will be formatted quite [...]

Connection String Parameters for Excel Data Sources2021-06-11T04:48:20-05:00

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

Opening or Linking Text or Excel as Data Sources in Microsoft Access2021-06-11T04:52:20-05:00

RESOLVED: Microsoft Office 365 Version 2009 May Break Your Database Application

Microsoft Office 365 Version 2009 May Break Your Database Application   Microsoft has reported that they've disabled the feature which should then avoid the need to rollback the version. The new feature will be made available in version 2010, planned for end of October 2020. In meanwhile, it wi [...]

RESOLVED: Microsoft Office 365 Version 2009 May Break Your Database Application2021-06-11T04:55:49-05:00

[UPDATED 2020-01-23] Microsoft Office 365 Build 1912 Breaks ODBC Linked Tables’ Identity

Microsoft Office 365 Build 1912 Breaks ODBC Linked Tables’ Identity **** Only applies to users on Access with SQL Server table links, otherwise this alert does not apply **** We are getting early reports that the build 1912/2001 released with Office 365 may break the ODBC linked table that contains [...]

[UPDATED 2020-01-23] Microsoft Office 365 Build 1912 Breaks ODBC Linked Tables’ Identity2021-06-11T05:26:27-05:00

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

[UPDATED 2] Critical: Office Update breaks Access — Query is corrupt2021-06-10T10:40:40-05:00
Go to Top