Go to Top

It’s time we gave the Access IDE some love

Quick: when  was the last time the Access Integrated Development Enviroment  (IDE) got a new feature?

I can’t remember. While Access in general has gotten love from the Access team, in particular the new data connectors, its time we add SOME kind of new feature to the IDE, but which one?:


  • Collapse procedures?
  • Improved Searching?
  • Intellisense for tables?

This month I’ll be discussing these ideas and more at our regular Access with SQL Server group meeting, to be held on Thursday February 15th, (note it will NOT be on our regular second Tuesday of the month), where I will welcome your suggestions and get the Access team to show some love to the IDE.

Please join me! For meeting info: Please click here

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

4 Responses to "It’s time we gave the Access IDE some love"

  • Bruce
    February 9, 2018 - 3:27 am Reply

    The “new data connectors” link is broken.

  • CW
    February 6, 2018 - 3:35 am Reply

    I definitely agree that the VBA IDE is painfully in need of an upgrade. However, you should note that the official position of the Access development team seems to be that comments on the IDE should be directed to the general MS Office team because the IDE is not an Access-specific feature.

    For instance, see this post on Access User Voice:


    Microsoft’s response:
    “Suggestions related to VBA editor should be posted in the Office Developers User voice site here – https://officespdev.uservoice.com/

  • Giorgio
    February 5, 2018 - 9:17 pm Reply

    Isn’t Access’ IDE shared with the rest of the Office suite? Then you’d have to have the other applications to change their IDE as well, wouldn’t you?

  • Maxim Ivashkov
    February 5, 2018 - 6:46 pm Reply

    Hi Juan
    just a couple of ideas what we need:
    1. Support for bigint for data from SQL Server
    2. Support for pivot tables/charts was removed , and it is a shame, put it back!
    3. Support for SSAS data (nice to have)

    Success with the meeting!

Leave a Reply

Your email address will not be published. Required fields are marked *


Contact Us
  • This field is for validation purposes and should be left unchanged.