fbpx

When should you use SQL Server with Access? (Hint: Almost always)

Look, I’ve heard the phrase “When all you have is a hammer everything looks like a nail” and given that our specialty is Access with SQL Server at IT Impact, you may suspect that is the case here. Using SQL Server with Access is such a wonderful combination, it would be almost criminal neglect to no [...]

When should you use SQL Server with Access? (Hint: Almost always)2021-08-01T12:47:20-05:00

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

Check Out the Latest News on Microsoft Access, Including Access 2022!

Check Out the Latest News on Microsoft Access, Including Access 2022!   Check out all the BREAKING NEWS Ebo Quansah released at my last Access with SQL Server meeting: https://accessusergroups.org/blog/the-biggest-news-from-ebo-quansahs-march-9th-2021-presentation/ #msaccess Access MVP Summit T [...]

Check Out the Latest News on Microsoft Access, Including Access 2022!2021-06-11T04:19:18-05:00

Avoid This Common Error When Executing Stored Procedure in MS Access

Avoid This Common Error When Executing Stored Procedure in MS Access   We love running stored procedures from our VBA code, but there is one issue you need to watch out for: Executing a procedure that affects data already loaded on your form. If you're not careful you will get the following [...]

Avoid This Common Error When Executing Stored Procedure in MS Access2021-06-30T14:54:20-05:00

Easily Convert Your Microsoft Access Queries With This New Tool!

Easily Convert Your Microsoft Access Queries With This New Tool!   AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL: https://accessusergroups.org/blog/accesssqltool/ As a firm that specializes in converting Access to SQL Server, this tool will be a rea [...]

Easily Convert Your Microsoft Access Queries With This New Tool!2021-06-11T04:20:49-05:00

Where to Download the Runtime Kit for Microsoft Access 2016

Where to Download the Runtime Kit for Microsoft Access 2016   If you ever need to download the runtime kit for Access 2016 you will find it here: https://www.microsoft.com/en-us/download/details.aspx?id=50040 If you expand the Details section you will see the following note: Note: There are mul [...]

Where to Download the Runtime Kit for Microsoft Access 20162021-06-11T04:17:41-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
Go to Top