Access Add-Ins for Developers

Click any image to view a larger version

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

AccessStudio1




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 Results

Query SQL Formatting

Image2
View Query SQL

View Query SQL

SQL Find

SQL Find
SQL Replace

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