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

isladogs

MVP / VIP
Joined
Jan 14, 2017
Messages
18,342
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
 
Last edited:
REMINDER
Access Europe meeting today at 18:00 (6 PM) UK time (UTC)
See post #1 for full details and connection info
 
Due to a very speedy burst of video editing by my colleague Alessandro Grimaldi, the video of yesterday's AEU meeting is already available on YouTube.

The files from the meeting can be downloaded from https://isladogs.co.uk/aeu-21/

Enjoy!
 

Users who are viewing this thread

Top Bottom