Version 1A First Published 19 July 2022 Last Updated 22 Aug 2022 Approx 1.96 MB (zipped)
Access Studio is an Access add-in which was created by Chris Arnold of SME Data Solutions.
The main purpose of Access Studio is to add much of the functionality of SQL Server Management Studio to Access apps.
Chris Arnold demonstrated his Access Studio application to the online Access Europe user group on 6 April 2022.
Further details of that session are available on the Access Europe website. See Topic Outline
Access Studio Window
Access Studio is loaded as a reference library and amongst its many features, it allows users to:
a) quickly switch between Access apps
b) use formatted SQL
c) run parts of more complex SQL code
d) add comments to query SQL
e) see query results in the same development window
Query SQL & Results NOTE: Adjustable Splitter Bars
|
Query SQL Formatting
|
View Query SQL
|
SQL Find
|
SQL Replace
|
Video:
The video of the Access Europe meeting from April 2022 is available on YouTube at https://youtu.be/d3LITmaqc10 or you can click below:
IMPORTANT
Chris Arnold has given permission for the free version of Access Studio to be made available here for use by other Access developers
Please note the following terms and conditions:
1. The free version of Access Studio includes:
a) ACCDE versions of the library file (32-bit & 64-bit)
b) a PDF guide to Access Studio
c) a text file with code for a ribbon shortcut
It has been made freely available for use in development projects by the person downloading the file
2. The free version of Access Studio is for use only by the person downloading it and may not be published or redistributed without permission
3. Any use in a commercial application will need the prior written permission of the author, Chris Arnold
(SME Data Solutions)
NOTE:
A commercial version of Access Studio with additional functionality should be available for purchase in Autumn 2022. Further details to follow.
If you have any questions or for further information, please contact Chris Arnold by
email
Click to download: Access Studio v1A 1.96 MB (zipped)
Colin Riddington Mendip Data Systems Last Updated 22 Aug 2022
Return to Access Add-Ins Page
|
Return to Top
|