Please provide a better SQL editor with syntax highlighting, indention, IntelliSense and using SQL comments in Access 2017.

Shortcut menus are very usefull and after access 2003 the interface for creating them has removed.You have to bring it back.

Permit (from VBA?) to instruct a program to run in a specific Core; so if we have a 4core PC, we can run concurrently 4 programs.

When complex SQL code in queries fails because of invalid syntax, you are not allowed to switch to design view mode to more easily spot the error- you must fix the error first.

A more robust error checker and formatter would be a big time saver.

With comprehensive applications, it isn't hard to get the dreaded "Can't open any more databases" error message.

When this message is encountered, bad things happen internally and the database should be restarted.

If this isn't possible, at least give us a handle so we can determine the number the system currently thinks exist.

Please add a standard way to backup your tables to an external database ( file or SQL) on time or in the case of a certian event.

Please design a wizard for dns-less coonections to SQL databases. Make it easier to use Access as frontend devolpment for different situations.
Other RAD tools have this already.

When database is created it should be possible to use it as a desktop database or to publish it onto for example IIS for a web usage without any changes to it. The publishing engine should be capable of rendering forms as a HTML5 user interface. VBA functionality should be interpreted as server side and or client side VB Script. Probaly forms should be saved as XML for that purpose.

Instead of separate window where coding takes place outside of form design, have it as a window positionable beside or below the form design.

Should be able to have a property for controls that can highlight when mouse passes over other than a button. Similar to Windows 10 Start menu or other Windows menus. This should also be allowed for a single row on a continuous form. Perhaps this could be a property in conditional formatting.

Allow a form to be MDI(or similar) so that you could place multiple subforms in a single form with framing, positioning and resizing… like Outlook

Create an enhanced table manager that allows users to specify data source (sql, access, txt etc), source table name, attached name, any passwords (encrypted or hidden) and primary keys so that the system will drop existing links and refresh as needed. You would need a couple of tables for data sources and data source tables but many developers have done this over the years and lots of examples that could be incorporated. This is used all the time.

Sometimes queries can be expensive, or have errors affecting performance. Currently, if one of these expensive (i.e. very slow) queries is in a form's or control's Data source, (like a Combo Box, for example), that query can be re-evaluate repeatedly and frequently (very slowly EACH TIME) making any effort to edit or design the form a legitimate pain in the keester. Give us the option to cache these query results during development (Design View) so we can work FAST, like Access is supposed to!

A lot of my clients want to be able to use Access forms on a tablet or touch screen. The controls really need updated to be compatible with touch!!! The worst offenders are scroll bars with list boxes and combo boxes close behind.

I understand this would require a re-wickering of Access forms, but this is difficult to accomplish in Access without some serious workarounds. At least have something like a Dialogresult property as in .Net so the user can get simple values from the dialog form when closed.

These buttons would work they way they do in other Office products.

Also, rename Align Left|Right|Top|Bottom for objects to include the word object. Align Left, for instance, is the tooltip for 2 very different things.

Please give us the ability to open a query in SQL view directly.

Also, when designing a query, don't process the records until we go to Datasheet View.