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.
-
Enable Password Decryption using a different Password
Users having the ability to Decrypt the Database is a huge security liability. Unencrypted databases enable Remote Queries which are very simple to create. Even the System Tables can be access by Remote Queries from another database.
4 votes -
Make Access an SDI program
I mis-wrote yesterday. What I propose is that Access offer an SDI user interface - Forms etc.. don't have to be modal and display in separate windows. Word and Excel have been upgraded to that mode of display, why not Access.
6 votes -
Add a VBA method to the Navigation Pane so the Search Bar text can be cleared or set
I have developed a few Access Add-ins that I use to extend the development environment (like a Navigation Pane replacement with features like Access 2003). I'm able to use VBA to select an object on the Navigation Pane, but only if it's visible in the current Search filter. I'd like you to add a method to the Navigation Pane so I can clear the Search Bar, or even better allow me to set the value. Does adding a method like this cause a lot of heartache for the Access team?
4 votes -
VB Code References Dialog Box should be sizable
If we open any VBA module (either a module or the one in code-behind-forms), one of the choices we have is pointing the Jet or Ace engine to the correct Reference Library. This dialog box is very small and should be bigger by default. Ideally it should be sizable and Access should remember the size where we left it. That would be NICE!
24 votes -
Import from Access to hide and ignore Msys tables
If you have set your nav pane options to show system objects, they should not show in the Import list.
1 vote -
VBA Application Add-Ins
Create a new type of VBA add-in (*.accda) that loads before the database is loaded, can display its own ribbon and is unloaded after the database is unloaded. This would enable VBA programmers to build application add-ins like in Excel or Word.
6 votes -
Improve the statistical capability of MS Access
Take on IBM SPSS Modeler. For example, work with the developers of R Statistical Computing to provide regression, clustering and neural network functions. At the very least extend the Domain Aggregate functionality to include a percentile capability.
7 votes -
file corruption. make access more robust. even with sql server backend is frontend corruption a problem
I would think after all these years MS has a pretty good knowldge about reasons for file corruption. It is quite the joy when The dreaded dialog that deletes Your vba Project appears...
17 votes -
bring it into conformance with high DPI design standards
Need to clean up all the UI to scale properly on high DPI displays. E.g., Navigation pane vertical object spacing, low res navigation pane object and navigation (expand/contract) icons, and "Save changes to the following objects" dialog box.
(Hate to spend precious votes on what is basically a set of defects, but there it is.)
65 votes -
Support strong-typed nullable data types.
In VBA, we can only store nulls in a Variant data type. But I hate this because this lacks information whether this is a string, a number or date. In SQL, those data types are all nullable but we have to constantly do Nz(), IsNull(), to avoid the nefarious error "Invalid use of Null".
Please make it possible for us to specify a nullable data type so that we also know this can be only either a null or a number (and thus prevent invalid entries of string in addition to writing self-documenting code).
12 votes -
Why is it so hard to get at database Objects' metadata?
These items are VERY useful when we are asked to go fix a previous coder/employee who may or may not be with us any more. Elsewhere in this forum others have suggested adding Notes field with date/time stamps for each object. I endorse that.
Would be really sweet if there was a quick way to get to items like the Description field in a Table definition, the existing Description field for objects (right click on object in Database or F11 window). I note that a right click is pretty quick, but this means you can only see one object at…
2 votes -
7 votes
-
Create an "Access Enterprise" version with most of the improvements we've suggested.
This new SKU would be welcomed by Enterprise IT departments and the professional development community if it lives up to their expectations. You can also charge a subscription or one-time payment for the Access Enterprise runtime's in order to fund the improvements we've requested in this site.
10 votes -
Provide an easy way to share Rich text between Access and other Office Applications
Access 2007 added the Rich Text control so we can store rich formatted text in Access. What it forgot to add was an easy way to share that formatted text in Excel or Word. Please add a means to share the rich text data in at least other Office apps and a easy way to strip the formmatting when exporting to formats like .csv.
33 votes -
Have "native english" Naviagation pane - even if using LanguagePack (like german)
It's hard to find things if you don't know the exact name in english if you search some things - especially because Help doesn't work / help.
2 votes -
wpf
wpf/xaml Controls and Windows
allow to insert wpf/xaml Windows to be placed in the forms-container.
so developers can switch partially the accdb apps to new databases12 votes -
java
Java Driver
please create a driver for java, so that it would be able to create a android frontend to accdb-databases3 votes -
Additional Error Object properties - which procedure, which module, which object, which db
The error object should be expanded to included properties which can reveal the procedure, module, and object that the error is taking place in.
0 votes -
CurrentModule, CurrentClass, CurrentProcedure properties
Create these properties so that when writing VBA Code they can be easily referenced. Example MsgBox "Hello Word", vbInformation, currentModule & " - " & currentProcedure
8 votes
- Don't see your idea?