AEU Meeting Date 3 June 2026 starting at 18:00 UK Time (UTC+1)	Last Updated 5 June 2026

Meeting Details:

This Access Europe meeting will be on Wednesday 3 June 2026 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:30 (7.30PM)

The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST

Please note that the UK is currently on Summer Time (UTC+1). For local times, please check World Time Buddy

We use Zoom as our meeting application. Please click this link to Get Zoom if you don’t already have it.

When the time comes for the meeting, please use the following link: Join Zoom Meeting
If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210

All sessions are recorded and later uploaded to the Access User Groups channel on YouTube

If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off during the meeting.



Download Outlook Calendar (.ics file):

Click to download: Outlook Calendar (.ics). Save in Outlook to create a recurring event for each month.



Topic outline:

Access and SQL Server can work well together; however, as an application grows and becomes more complex, they can become more challenging to manage and performance may decrease.

Access is often blamed for these performance issues due to its somewhat unjustified reputation of not being a 'real' development tool. However, many of these issues can be addressed through a more efficient use of SQL Server.

This session will provide tips and tricks to make SQL Server work for you. Various SQL Server techniques will be explored. These are proven but not widely known or used by Access developers.
The focus is on practical changes that deliver significant improvements in readability, manageability, and performance.



Background:


Kevin started his career with Access 1.0 and has worked with SQL Server since version 4.21. With over twenty years of consulting experience, he develops custom applications using SQL Server, Blazor, React, and Access. In 2008, he joined the Microsoft Access Team as a test engineer, contributing to Access 2010, 2013, and 2016.

Outside work, Kevin enjoys cycling, baseball, international travel, and sampling quality ales.

Website: https://accessui.com



Download:

All files used in this presentation are now available for download. The zip file contains:
•   a PDF of the presentation
•   SQL Server script files
•   the example database

Click to download:   SQL Server Tips & Tricks     (zipped)

In addition, you will need to install the free SQL Server AdventureWorks example database (version 2019 or later). This can be downloaded from: AdventureWorks sample databases

As is the case for all files downloaded from the internet, first unblock the downloaded file(s), unzip then save to a trusted location.
For more details, see my article: Unblock downloaded files by removing the Mark of the Web



Video:

Unfortunately, the video of this month's session is not available for viewing. If possible, a replacement recording will be substituted later.
This article will be updated with a link to the new video if that happens.



Feedback

Please use the E-Mail button in the contact form below to let me know whether you found this article useful or if you have any questions.

Please also consider making a donation towards the costs of maintaining this website. Thank you

Colin Riddington	Mendip Data Systems	Last Updated 5 June 2026

Return to Access Europe Page

Return to Top