We should be able to generate reports as PDFs with a password. MS Word has an encryption option when saving a Word Doc to PDF.

For security reasons, more and more organizations want to have encrypted data at rest and in emails. ACCDBs support encryption, so it'd be helpful if it's PDF outputs could too.

It should be available from the user interface and as an option programmatically (DoCmd.OutputTo acFormatPDF).

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.

When building a system that shares its data with other systems - I've built an ERP system with Access - you often want to share certain Master data (from the HR system for example), but want to keep it that only HR can modify the data.
If we could set linked tables to be read only, that would remove the need for a lot of 'protectionist' coding.

Replace/remove Ribbons out of Access (or better out entire Office).
Nearly every, even the smallest little and tiny application has an better menu structure than this space taking ugly ribbon thing. Besides, now we must conclude that after 8 years of introduction there is still no decent ribbon builder included within Access it is time to get rid of it. Lets say, it was a nice try, but let's return to something better please.

A TreeGrid control could be used in forms, or as just a Tree control. This should be a somewhat customizable look and feel.

When connecting to a commercial database such as Oracle, it may be trouble if all the columns of the table are not displayed.

As per Excel, it would be great to highlight and distinguish field data between the records displayed. Currently, if a format is set on a field, in a continuous form, the entire column receives that format, whether or not the data value contained, matches the criteria.

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.

Often the Datasheet heading is much longer than the values in the column under the heading. Making the column narrower (to see more columns) means I can no longer read the heading.

Whenever I modify a table or a view in SQL server I need to go refresh the table link. Currently that means
* right click a table
* Select Linked table manager
* Find the table I want to refresh
* select it
* click refresh table links

I would really like it, if we could simple right click a linked table, and just select refresh to have that single table refreshed.

Whenever an ITEM such as a heading progress bar is in the Detail section, so if you display the form as Continuous Forms, you will see a progress bar in each displayed record. It will happen whenever a Continuous Form displays more than one record.

The only way to avoid this is to move the progress bar to the form header (or footer) section.

Please refer to the attached design, on the very last page described in microsoft forums.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_windows8-mso_2010/crosstab-query-to-display-all-records-according-to/b98b9372-1a83-402d-b54d-87ca5b7a7407?messageId=c8966d76-2bcd-4a49-a1cc-83cdcf71a483

Either an access development enhancement to enable this would provide more flexibility to create complicated reports.

Thank you kindly.

When creating objects such as forms and reports it would useful to be able to have a dialogue form where you can key in notes and a date to keep documentation current. Have a few columns for date, user notes and developer notes. On the ribbon, have a notes icon which will open the notes to the current object for display and edit. Have it link to the ID Field in Msysobject table.

There are two undocumented methods, SaveAsText and LoadFromText, which were originally used for the old SCC integration. Since Access 2013, the source code integration has been removed and we now rely on third party tools (e.g. OASIS-SVN or Ivercy being example). It is my understanding those still rely on the undocumented methods. This request is to ask that Access team document those methods and thus make it supported so that those tools can continue to count on it being available and provide a solution for source code without taking any resources from Microsoft.

I have never understood why after all the effort put into compiling Forms and Code in Compiled Access databases and then they leave the Navigation Pane exposed so that all Tables are revealed and accessible to end users. Sure you can hide the Navigation pane but anybody can go into Options and reveal that Pane.

This has been a major negative to Access for me for years ....

Dick

When a tablet or PC goes into sleep mode any active form looses its connection to the database backend (I am using SQL Server). This is very annoying in tablet environments where the PC is frequently switched to sleep mode. Make it so that Access can detect a reawaken from sleep and refresh the connection automatically rather than leave an error so that the user doesn't have to log off and reload the screen.

The Adobe PDF-Format allows to implement form-fields. This fields could be filled in by the receiver of the PDF-File.

In my opinion it would be great to generate an PDF-File with Access with form-fields. If the data from Access could be pre-filled in, this would be great.

The generated PDF could then be sent via Email to a client. The missing data could be filled in direct with Adobe Reader and then printed out.

At the moment the PDF-Export just generate an PDF-File without form-fields.