Feedback by UserVoice

Access (Desktop Application)

Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Provide a MS-Access connector to PowerApps and Flow

    We have a webservice on which we have a PowerApp connector that enables PowerApps to run any macro, vba procedure/function, opening of a form to fill in text-fields and/or perform the equivalent to buttonclick-events in an Access Application. If MS-Access out of the box could configure and enable a webservice on the machine it's running and thus would enable a PowerApp to be a cloudfirst/mobilefirst frontend presentation layer, MS-Access 2019 would really become something new. When the Access application has linked SQL-tables to SQL-2016 or up, it can easily delegate the creation of JSON to SQL-server, but I wouldn't be…

    153 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  2. JSON import/export

    Given the widespread use JSON as a data transport, we should have:

    Application.ImportJSON
    
    Application.ExportJSON

    like we have:

    Application.ImportXML
    
    Application.ExportXML

    There are a few libraries out there – replacing these with one or a few lines of code would be extremely useful.

    98 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  3. Access database in an inconsistent state...Windows 10 1803 update

    Access database in an inconsistent state....since the release of Windows 10, 1803 our significant percentage of our 3500 customers have consistently lost connection to the back-end database and been forced to stop work during the day to repair their database. Only recently did we discover the leasing fix. In the meantime, our product reputation has been adversely affected. Please release a production update since many of the IT people have refused to make the lanmanserver registry entry and are waiting for the Windows update. HELLO MICROSOFT PLEASE HELP!!

    61 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  4. Import/export specs edit feature

    Currently, the developer needs to go through the process of importing a file into a database in order to create or edit an import/export spec in the MSysIMEXSpecs table. True, the MSysIMEXColumns can be edited directly in the table, but overall, the process is not very user friendly. There needs to be functionality to create/edit import/export specs without have to pretend that one is importing an external file.

    44 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  5. make set_spapprole work in a VBA context

    SQL Server (see https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-setapprole-transact-sql?view=sql-server-2017) has a great security feature to allow an app to assume a security role when connected to the server. This doesn't work from Access VBA. This leaves us having to give permissions to data that users can subvert. Whilst this can be mitigated, if Access could connect using a user account with no permissions, and switch to an app role with the right permissions security would be wonderful. SetAppRole is particular pleasant in that in the context we still know the original user who started the app.

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add the ability to import selected VBA references in the Import Objects dialog

    A frequent task in Access is to import some or all database objects from an existing database into a blank new database. After that, we must painstakingly set all non-standard VBA references in the new database the same way as in the old one.
    It would be nice if we could specify in the Import Objects dialog which references should be copied from the existing database into the new one.

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  7. ODBC errors need to return more information error 3146 does not provide enough detail

    Perhaps an error.description2 property which we can reference which stores the error returned from SQL about the true problem. Right now it is very difficult to trouble shoot.

    Thanks.

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  8. Attach SQL tables without "dbo_" or give the option to do so

    It would be more intuitive to link sql tables WITHOUT the owner prefix.

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  9. Create ACE Engine Redistributable for Access 2016!

    Since Office Click-to-Run Installs can result in the ODBC / OLE-DB Drivers for ACE NOT being visible to the system outside of the VDI install environment, we need a CURRENT version of the ACE engine redistributable package (the last one being from Access 2010 - 6 YEARS AGO!)

    For more info see: https://support.microsoft.com/en-us/kb/2874601

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  10. add ETL-features to ACCESS (retry of: Add PowerQuery to ACCESS)

    I still do thoroughly hope, you will integrate ETL-features to Access!
    In EXCEL as well as in PowerBI you can use "retrieve and transform data" to collect data from diffent sources.
    I don't want to write back data to the sources.
    Many of my clients - financial controllers and data analysts - use ACCESS as a kind of datamart for their reporting, as I wrote in my BLOG "controllingexcellent". They collect data from different source, mostly TXT-files, CSV, Web, EXCEL-Files and Databases at the same time.
    It is the "single source of truth" where data is stored. Many other reports…

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix the TransferDatabase command so that it exports tables to Oracle properly.

    When I try to export an Access table into an Oracle database it doesn't retain the input field formats. Everything is converted into a string and the indices are lost. I've contacted Microsoft about this before but got no meaningful response, presumably for petty proprietary reasons.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  12. Encrypt password in MSysObjects

    In a frontend/backend scenario with linked tables to a password secured Access backend the password can be figured out. It is human readable in the Connect field of the MSysObjects table in the frontend. Please prevent this by encryption.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow users to import text files that do not have a txt extension

    in office access 2007 we used to be able to import text files that have an extension other than .txt, many businesses have files that are text files that do not have .txt extension and although I can change the extension to .txt, it is very time consuming when I have thousands of these files

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  14. Enable Access to work with Azure Multi-Factor Authentication

    There seems to be no way of allowing Access to link to an Azure SQL database where Azure Active Directory Multi-Factor Authentication has been enabled. This means that if an IT department switches on MFA Access can't connect to an Azure SQL database it can connect to where MFA has not been activated.

    If I have missed something, please tell me!

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  15. Data Connector For QuickBooks Online

    We are currently developing and testing a dotnet interop app that allows an Access frontend to integrate with QBO via API calls, and was wondering if you would be interested creating a QBO data connector.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  16. Link to Outlook WebApp contacts folder

    Create a link to Outlook WebApp contacts folder.
    The connector already existing depends on an Outlook PC/MAC version to get the data from. I suggest creating a connector directly to the contact's server folder.
    That way it would be possible to edit easily a list of Outlook WebApp contacts in Access.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  17. Choose columns when linking to Salesforce (see power query)


    • make it possible to select a subset of fields from a Salesforce object

    Primarily, this would make it possible to work with SF objects that have exceeded the limit of 256 or whatever it is for Access. There would be other benefits too. But this alone would make the Salesforce/Access integration much more doable (right now I have to use an intermediary such as power query or sql server for these larger objects)


    • make it possible to link to Salesforce reports. (less important but very helpful)

    1 is really very necessary. I'd go so far as to say that without

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  18. Synchronize the field Notes of Outlook Contacts with Access

    You can easily synchronize your Outlook Contacts with an Access Database, but there is one field that is not synchronized: the notes field.

    I would like to have the notes synchronized with my database.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  19. Implement support for (ADO) linking SQL tables and views using Microsoft OLE DB Driver for SQL Server

    There is only support to use the ODBC driver for linking tables and views to Access 2016/2019 databases. For ADO we need to avoid mixing connection string and database access technologies.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  20. im bald

    im balder than bald

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base