Access Europe – Peter Bryant (Automating DSN-Less Connections to SQL Server)

Please join us for our monthly Access Europe session on Wed 3 May 2023 at 18:00 (6:00PM) London time (UTC+1)

———————————————————————————————————————————————————-

Topic:    Automating DSN-Less Connections to SQL Server

Code (and some data) to enable you to fire and forget application upgrades to different networks.  Just build and send the customer the ACCDE that works on your development network and have it automatically re-connect to their server and database on first run.  It works with more than one target SQL Database in the system.  The user then just saves that new ACCDE to distribute to users.  The solution has been proved with many clients and the code will be available afterwards; also included will be instructions and all the SQL Scripts you need to create a test environment to prove the code before trying to put it into your own projects.

The test application (which will come with the downloads) also demonstrates how you can switch the front end between your (or your users’) TEST, UAT and LIVE environments at just the click of a button (subject to version numbering).

The presentation will show you how it all connects up and how you can add to your existing projects.

 

Bio: Peter Bryant (pbryant@corylus-business.co.uk)

Peter has run his own consultancy since 2004 and specialises in not specialising for many different sectors. A user of Microsoft Access since the beta program three decades ago his projects are as much (if not more) about data analysis, function and business problem solving rather than amazing code.  Projects are generally lengthy prototyping/agile style projects when the client starts out quite unsure of their expected final requirements.

A regular speaker at the UK Access Group for over a decade, he also has a source code licence for Andy Couch’s excellent MUST software and performs Access backend migrations to SQL Server As A Service.

Do join us

 

======================================================================

IMPORTANT NOTE

All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTubeAccessUserGroups.org – YouTube.

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

======================================================================

We use Zoom as our meeting application.

Please click the link below to download Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link or phone number

Join Zoom Meeting

If you are asked:

Meeting ID: 924 3129 5683
Passcode: 661210

Dial by your location:
+1 669 900 9128 US (San Jose)
+1 253 215 8782 US (Tacoma)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 346 248 7799 US (Houston)
+1 646 558 8656 US (New York)
+43 12 535 502 Austria
+32 1579 5132 Belgium
+359 3 257 1633 Bulgaria
+385 1300 0988 Croatia
+420 5 3889 0161 Czech Republic
+45 32 70 12 06 Denmark
+358 9 7252 2471 Finland
+33 1 7037 9729 France
+49 69 7104 9922 Germany
+30 211 198 4488 Greece
+36 1 779 9126 Hungary
+353 1 653 3898 Ireland
+39 069 480 6488 Italy
+352 2786 4277 Luxembourg
+356 2778 1288 Malta
+31 20 241 0288 Netherlands

+48 22 307 3488 Poland
+351 308 810 988 Portugal
+40 31 630 1088 Romania
+421 233 418 515 Slovakia
+386 1600 3102 Slovenia
+34 917 873 431 Spain
+41 43 210 71 08 Switzerland
+46 850 539 728 Sweden
+44 203 481 5240 United Kingdom
+44 208 080 6591 United Kingdom

Meeting ID: 924 3129 5683
Passcode: 661210
Find your local number: https://zoom.us/u/a4d0JdR88