Search results for: SQL Server

Need a new search?

If you didn't find what you were looking for, try a new search!

Access With SQL Server Meeting is back this January 9th!

2024-01-08T09:06:11-06:00

Join me this Tuesday January 9th, 2023 at 6:30 PM as we start exploring tools that will help you be more productive. Here are the details: Join us this Tuesday, January 9th for the Access SQL Server Meeting! Session Title: Tools to help you automate Access coding – with FMS founder Luke Chung This m [...]

New Drivers For SQL Server… What You Need to Know

2022-03-08T07:46:52-06:00

Recently, Microsoft released two new drivers for SQL Server, a major upgrade: ODBC 18 Driver for SQL Server OLEDB 19 Driver for SQL Server That's great news! However, there is a major breaking changes that requires your attention. Specifically, they changed how the default settings work for the encr [...]

Access-compatible Wide World Importers SQL Server Database

2021-12-06T14:39:15-06:00

SQL Server usually comes with useful sample databases to demonstrate new features and some possible design. I usually find sample databases far more useful as a playground for developing generic components against an existing database to use in other projects. I find that using a empty or too small [...]

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

2021-11-09T17:35:51-06:00

[Update] Post has been updated to correct the maximum size of the database to 10 Gigs 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 I [...]

Join Us for an Intro to Access with SQL Server

2021-06-11T05:03:15-05:00

Join Us for an Intro to Access with SQL Server   On Tuesday September 8th, 2020 at 6:30 PM CST we are back from summer vacation to start the new season! We will start with introduction to Access with SQL Server, you can learn more at https://accessusergroups.org/sql-server-with-access/event/375 [...]

Alternative Solution to DCount and DLookup with MS SQL Server Backend

2021-06-11T05:05:57-05:00

Alternative Solution to DCount and DLookup with MS SQL Server Backend   One of the major issues we have encountered with Access is the use of DLookup and DCount when using SQL Server tables.  We recently worked on migrating a pure Access solution to SQL server and encountered delays on the load [...]

Search Microsoft SQL Server Database for Stored Data

2021-06-25T07:30:03-05:00

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

Learn How to Performance Tune Microsoft SQL Server

2021-06-11T05:25:04-05:00

Learn How to Performance Tune Microsoft SQL Server   Please join me on February 11th, 2020 when I'll have special guest Jacob Golden from https://www.imyourdba.com/ to discuss how you can improve the performance of your database on SQL Server, can't miss talk! Learn more here: https://accessuse [...]

Catch my ‘Optimizing Microsoft Access with SQL Server’ Presentation

2021-06-11T05:33:14-05:00

Catch my 'Optimizing Microsoft Access with SQL Server' Presentation Next week August 12, 13 and 14th I will be doing a different SQL Server PASS group each night in Iowa, it’s the perfect opportunity for you to catch my “Optimizing Access with SQL Server” presentation if you live nearby live and in [...]

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

2021-06-11T05:34:40-05:00

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

Go to Top