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. Incorporar la tecnología de Project Nucleus a las listas vinculadas

    Con Project Nucleus las listas se sincronizarían con una BD local con lo se podría trabajar sin conexión y se eliminarían los problemas de las listas demasiado largas. Si esto funcionara también con las listas vinculadas, Sharepoint se convertiría en un estupendo back-end para Access.

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  2. Create a connector for SharePoint

    Hi,

    In the menu External Data > New Data Source, there is no way to connect to an Excel file stored in a SharePoint folder.

    That's a problem because more and more companies use SharePoint and all the Excel in the SharePoint are "invisible" for Access

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  3. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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…

    42 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 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…

  5. 775-848-3156 Joseph V. Popolo

    Tel Contact 775-848-3156

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  6. Best EDB to PST Converter Software

    Easily recover lost and permanently deleted data with the help of EDB to PST Converter application that is designed by using the rich algorithm and the best technology. It helps the user to convert the required folders from priv 1.edb file and pub 1.edb file included with the email, notes, tasks, attachments, contact, draft, inbox and calendar (For, CC, From, Date, Time, Subject, Object, and Cc). It not only recovers data but also converts into new PST file format included with all properties of email like To, Cc, From, Date, Time, Subject, Object, and Bcc. Using it the user can…

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  7. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  8. Fantastic universal boot ! Keep it UP

    Fantastic universal boot ! Keep it UP

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  9. Fix the issue of Access returning an incorrect record ID when a bound form is connected to a SQL Server table that has an insert trigger

    Access returns an incorrect record ID when a form is bound to an SQL Server table that has an 'insert trigger' that inserts a record into 'another' table. The record ID returned is actually the record ID of the trigger inserted record into the 'other' table. This is because Access calls SQL Server for @@IDENTITY rather than SCOPE_IDENTITY() when inserting a new record. This particularly affects SQL Server tables that are 'replicated' as these tables have an MS shipped 'insert trigger' on the table for use in replication. We have an MS Support Case # 23043471 where we have had…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  10. Update data in access to update your power point presentaion

    like if you change data in access table your powerpoint presentation itself get updated

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  11. LoCode Office Automation Connector for Power Automation/Flow

    Provide a Power Automation Connector that enables Desktop Excel/Access/Word to connect at its backside and makes data and VBA UserDefinedFunctions returning JSON strings (or anything else a Function returns) accessable to PowerApp-, HttpActionInitiator-Flows atl.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  12. Exception thrown at 0x00007FFBE978137D (Mso40UIwin32client.dll) in *.exe: 0xC0000005: Access violation writing location 0x0000000000000000.

    am getting above exception during call of SQLDriverConnect(...). Very first time I am able to connect thru DB (MS Access), but next time after session out, when trying to re-connect getting exception.
    Using x64 windows machine with VS 2019 enterprise edition. Please help me.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  13. Fix a Bug! Filtering problem on persian Ye on linked tables

    Seems to be a Bug!
    Filtering on a filed containing ی (persian ye = unicode 1740) finds ي (arabic ye =1610) on linked tables; while searching and sorting are correct. this bug does not appear on local tables, just on linked tables.

    Test environment:
    - data table reside on MS SQL Server 2017
    - Data fields are NVARCHAR
    - MS ACCESS 2016 linked table over ODBC 11

    Please type with Persian keyboard layout

    this bug existed from previous versions and is know to Persian language users and I don't know if someone has reported or not before.

    I can provide…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  16. GOOGLE DRIVE DUMP TO ONE DRIVE

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

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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.

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  20. j

    meth

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    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