Access Europe – Chris Arnold (Access Studio)
Chris Arnold will be presenting his new and very powerful Access Studio application.
This should be an exciting start for our forthcoming series of monthly presentations.
The meeting was held on Wednesday 4 April at 18:00 (6PM) UK time (currently UTC+1).
This is equivalent to 19:00 (7PM) in Central Europe / CEST (UTC+2) and 10AM in Seattle / PDT (UTC-7)
For other local times, see https://www.worldtimebuddy.com/
Chris is a qualified management accountant who before moving into consultancy in early 2000 was a finance director of a number of large and small companies.
His first introduction to programming (other than some small experience at school) was in the mid 70’s to create a production control program on an Apple IIe using UCSD Pascal. It had a whole 8k of memory and a pair of 143k floppy disks. This later grew to a full ERP system.
He was one of the first people in the UK to network a number of Apple IIe’s together in a commercial environment using a 40mb Corvus hard drive and with the permission of his employer at the time was invited by Apple to present his experiences (warts and all) to a number of business groups around the country.
After that, although still programming to a certain extent, accountancy became his primary direction of travel until he started a business in the mid 90’s and needed to develop some bespoke solutions to meet the new company’s requirements. It was at this point he discovered Access 97 and has continued to work with it and its successors ever since.
In early 2000, he sold the business and moved into full time contracting/consulting primarily in the arena of resolving conflicts between different corporate systems which resulted in losses to the business. To date he has identified around £1/2 billion of annual savings across many clients.
Chris has been developing in Access since the mid 90’s and is a regular contributor to several Access forums. His clients range across a wide spectrum of industries from national and international companies down to small internet traders.
His current website is smedatasolutions.co.uk. Chris is now developing a new website to share some of the code and best practices he has developed over the years.
Being a regular user of SS Management Studio, Chris really wanted similar functionality to manage MS Access applications – quickly switch between applications, formatted SQL, run parts of more complex SQL code, add comments, see results in the same development window to name a few.
The much delayed Monaco SQL editor for Access promised by Microsoft is now due Dec 2022, however it seems that it will only have a small part of the features in Access Studio.
This session will demonstrate part of the code used to manage the application which will be available as a standalone .ACCDE file in 2 versions: – a free entry level version with limited functionality and a commercial full version with full functionality. A free copy of the full version will be made available to those who attend the presentation.
All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTube: AccessUserGroups.org – YouTube.
If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off.
We are using Zoom as our meeting application.
Please click the link below to download Zoom, if you don’t already have it.
To join our meetings, please use the following link or phone number
If you are asked:
Meeting ID: 924 3129 5683
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
Find your local number: https://zoom.us/u/a4d0JdR88