fbpx

SQL Server with Access Articles, tips and tricks

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

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

Search Microsoft SQL Server Database for Stored Data

Search Microsoft SQL Server Database for Stored Data   Have you ever had to decipher a database and identify which column has the data you need? I recently had to work with extracting data from a SQL database to use in Microsoft Access and Power BI, unfortunately the naming structure of the dat [...]

Search Microsoft SQL Server Database for Stored Data2021-06-25T07:30:03-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

Join Me For a Microsoft Access with SQL Server Academy Session

Join Me For a Microsoft Access with SQL Server Academy Session We kick off the new season of Access with SQL Server group meetings this year with three months of training: Introduction, Intermediate and Advanced topics on how to optimize Access with SQL Server. Part 1: Introduction On Tuesday Septem [...]

Join Me For a Microsoft Access with SQL Server Academy Session2021-06-11T05:48:32-05:00

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

Designing a Microsoft T-SQL Trigger2021-06-11T06:11:38-05:00

Drag and Drop In MS Access and Conditional Sorting

Drag and Drop In MS Access and Conditional Sorting Drag and Drop In MS Access Doug was on a roll in January of 2004 when he wrote his article on drag and drop in MS Access. He tested it now using Access 2016 and it still works. This article shows you how to add drag-and-drop to your Access applicati [...]

Drag and Drop In MS Access and Conditional Sorting2021-06-11T07:25:31-05:00

Unanswered Questions About MS SQL Server Security and Access Control

Unanswered Questions About MS SQL Server Security and Access Control For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude [...]

Unanswered Questions About MS SQL Server Security and Access Control2021-06-11T07:32:51-05:00

Avoid Number Conflicts with Microsoft SQL Sequences

Note: I'll be presenting on this topic at the Access with SQL Server group online. Please join me on September 13th at 6:30 PM CST, join the group to get an email with all of the meeting details, it’s free!

Avoid Number Conflicts with Microsoft SQL Sequences2021-06-11T07:36:48-05:00

Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL

Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL When we design Access with SQL Server solutions we almost always add CreatedBy and CreatedOn to all of our tables, allowing our clients to see who created records in the Access frontend. Script to add CreatedBy and CreatedOn Automatica [...]

Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL2021-06-11T07:38:18-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