fbpx

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

Avoid This Common Error When Executing Stored Procedure in MS Access2021-06-11T04:19:50-05:00

7 Step Guide to Using Access with Azure Multi-Factor Authentication

7 Step Guide to Using Access with Azure Multi-Factor Authentication One of our clients wanted to use Azure multi-factor authentication with Microsoft Access and Azure SQL, requiring users to authenticate when they launch Access through a second validation at least once every 60 days. Step 1: Extend [...]

7 Step Guide to Using Access with Azure Multi-Factor Authentication2021-06-11T05:29:42-05:00

Optimizing Microsoft Access with SQL Server IndyPass – 5/21/19

Optimizing Microsoft Access with SQL Server IndyPass - 5/21/19 Join me on Tuesday May 21st 2019 as I present Optimizing Access with SQL Server to the great folks at IndyPass. I’ll be discussing all the great tips and techniques we use with clients around the world. Pizza will be served as well. Abst [...]

Optimizing Microsoft Access with SQL Server IndyPass – 5/21/192021-06-11T05:34:40-05:00

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

Detangling the New Microsoft SQL Server ODBC and OLEDB Drivers2021-06-11T05:47:43-05:00

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

Pitfalls to Avoid When Using the New Microsoft SSMA Version 7.82021-06-11T05:49:24-05:00

Use Microsoft SQL Server Native Client 11.0 for the Best Performance

Use Microsoft SQL Server Native Client 11.0 for the Best Performance [Update] There is a newer version of this post here. In our experience in using linked tables with Access, we get the best response using Native Client 11.0 with DSN-less tables. You could use ODBC 11 for SQL Server but then you wo [...]

Use Microsoft SQL Server Native Client 11.0 for the Best Performance2021-06-11T07:40:50-05:00
Go to Top