Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)

Please note that the UK and Europe revert to winter time on Sunday 29 Oct, whilst the USA remains on Daylight Savings until mid November.

The start time for this meeting is equivalent to 19:00 (7PM) in Central Europe and (for this month only) 11AM in Seattle / PST
Due to the clock changes, please carefully check World Time Buddy this month for all local times

This session will be led by John Heaser who is an experienced Access developer based in the U.K.

Topic outline:
SQL Server has a Geography data type that can represent points, lines and polygons on the Earth’s surface. This data can be used to:
• Find which polygons contain a point:
e.g. find the Local Government Region for a location where you know the Latitude/Longitude (Lat/Long can be found from the PostCode)
• Find the points that lie within a radius of a starting point and order them by distance:
e.g. find the Stores that lie within 50 miles of a customer and show them in ascending order of distance

This can be very useful for many purposes and SQL Server calculates the results very fast - provided that suitable Spatial Indexes are defined.

Unfortunately Access can’t work directly with Geography data types! However, you can make use of Geography data in Access by using:
• Persisted Computed Columns
• Scalar Functions
• Stored Procedures
• Triggers

We will look at how these SQL skills can be used to bring the benefits of Geography data types to Access.
The same skills can also be used to leverage the power of SQL Server to do other tasks that would be slow to perform or difficult to code, if done directly in Access.

For more details about this month's presenter and session content, see: https://accessusergroups.org/europe/event/access-europe-2023-11-01/ or https://isladogs.co.uk/aeu-21/

The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting.
If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210

For more connection options, please see the AccessUserGroups.org web page for this event

As always, the session will be recorded and the video uploaded to YouTube after the event