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. Integrate MS Access with Power Apps

    I've been looking more into Power Apps, and I think it would be great for you to work with the Power Apps team to provide a web and mobile solution to what Access can do today on the premises of a server. Because there is unfortunately no web version of Access, maybe Power Apps can help solve this problem? Ideally, we should be able to continue moving (and linking) Access data into SQL and then create a Power App on top of the "Access-created" data from SQL; essentially viewing a Power Application that looks exactly like access but online and…

    13 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 →

    This is great feedback that we are actually working on providing now. Using the comments below, we’d love to hear thoughts about solely focusing on SQL as a stepping stone to Power Apps for data migration purposes, or also investing in another way for you to connect to Power Apps through the Common Data Service (CDS). This database allows you to store, share and manage your data over the web, and eventually the phone (current MS investment). CDS is also Power Apps’ central underlying storage unit, as well as the entire Power Platform team’s key investment.
    Please see following link for information about CDS, and let us know: if Access created a data export & linked table capability from our platform to CDS, would you use it?:
    https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fdata-platform-intro&data=04%7C01%7CEbo.Quansah%40microsoft.com%7C32c26c86b7fe4f3162a508d7f069896d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637242208373640123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C-1&sdata=GuvQ6o2aqKiBMs%2B1z2nvv0sNtAHNl8MPQqiOvsh0D1U%3D&reserved=0

    We will still continue to make investments in SQL connection either way, but we are also happy to…

  2. XML Export and Import of Large Number (BigInt)

    I can't complete round trip ExportXML and ImportXML of a table that contains a "Large Number" (BigInt) field. Currently, the BigInt field is stored in the XML output with an attribute:
    <xsd:restriction base="xsd:decimal">
    When the XML that was exported from Access is imported back in to Access the field type is changed to "Number" and then all values that are bigger than Number fail to import.

    When you say that you support BigInt I expect built-in functions to support it. You can test this using the export and import buttons in the GUI.

    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 →
  3. Querydef as source for subform

    We have no way to use querydef as subform soure
    Problem
    Option 1 use ado - disadvantage - no master child
    Option 2 - linked table - disadvantage - no server side filter, can bring millions of records to client - stupid and ineffective
    Suggest
    Option 3 - querydef as standard snapshot recordset for all forms and subforms and server side filter
    You are 15 years behind.

    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 →
  4. GOOGLE DRIVE DUMP TO ONE DRIVE

    CREATE A APP WHERE I COULD FUNNEL MY DOCS FROM GOOGLE DRIVE

    1 vote
    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 →
  5. Enhance Import Fixed Width Text wizard with ability to indicate that first row contains column headings

    When importing delimited text (e.g. CSV) one can indicate that the first row contains column headings.
    This ability does not exist for fixed width text. It should, to make the feature more useful and consistent.

    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 →
  6. 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…)
    1 comment  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  7. j

    meth

    1 vote
    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 →
  8. Develop a mobile version of Access so it can be installed on a lightweight android device.

    Develop a version of access that can be run on a lightweight android device or an application that can be run from the cloud.

    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 →
  9. 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.

    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 →
  10. Implement large number support in OLEDB

    When Large Number support is enabled in an access database, it becomes unavailable to OLEDB with the error "The database you are trying to open requires a newer version of Microsoft 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 →
  11. 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 →
  12. Allow load data from / link to Excel Table

    Display Excel Table names in the Wizard when loading/linking external Excel data, currently only specific name range or the spreadsheet is visible.

    4 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 →
  13. New Linked Table Manager - quick fix for Escape key

    In the new Linked Table Manager, when I click the Relink/Add/Delete/Edit button a dialog is shown. If I press the Escape key, I expect that dialog to close, which it does, but the Linked Table Manager also closes. This behavior is annoying.

    Please change these dialogs so pressing Escape only closes the top window.

    1 vote
    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 →
  14. 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!!

    72 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →

    We are well aware of this issue and are working closely with the Windows team on resolving it. Although we believe we have a solution to the problem, it introduces some new issues that we need to investigate and resolve before we can deploy the fix.

    Regards,
    Access Engineering

  15. 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 →
  16. Base Access

    Hello
    I use Access since its version1. Until today I have not found an equivalent in terms of reliability and speed in development. Since then many improvements have been made on various options, except to the engine of the base. What it lacks today is native access to SQL express server. This would help with a seamless, easy and efficient transition to standard SQL server.
    Thank you.

    2 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. 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.

    111 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  18. Fx ODBC issue where column name of 64 characters is 1 too many

    When the Linked Table Manager sees a column name in a SQL Server table with 64 characters, it only uses the first 63 characters of that column name.

    After linking, an attempt to view table data will fail, with the message

    "ODBC--call failed"

    "[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name "'123456789012345678901234567890123456789012345678901234567890123'."

    The column name in my table on SQL Server is:

    "1234567890123456789012345678901234567890123456789012345678901234"

    So Linked Table manager is truncating that for some reason.

    There is a 64 character limit for object names.

    I cannot find any documentation anywhere saying there is such a limit of 63 characters in ODBC…

    6 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 →
  19. Fix new Settings Incompatibility Bug

    I believe I have hit a new bug in ACCESS.
    This conflict shows up when a front end using standard Access SQL connects to a Back-end using SQL Server Syntax (ANSI92).
    It results in very strange behavior with Combo-Boxes failing to Auto-Complete and Wildcard Queries not returning results.
    Access 2010 is immune! Phew.

    It is repeatable and can be reproduced by following the process:
    There appears to be a new bug in ACCESS 365 / Click to Run.
    It DOES NOT EXHIBIT on Access 2010, but I have not tested with 2013.

    Issue: Combo Boxes (drop-downs) fail to Auto-Complete List…

    1 vote
    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 →
  20. ONE DRIVE - Survey Creation and Data Collection

    As One Drive is Cloud based, I'd like questionnaire templates that I can then customize for my interests / requirements using either MS Excel or MS Access. Then once created, I'd like to be able to 1) Invite Specific Respondents to fill in the questionnaire via a link; and 2) Post the Survey on a separate website with the data being saved in my specified One Drive Folder. It would be great if the templates or template forms came with easy-to-use or paste items for building the questionnaire such as contact info, date formats, text formats number formats, logic formats,…

    1 vote
    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 3
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base