Fix Access Database Documenter Showing No Objects Selected Error
Question details
The user needs to generate documentation for Microsoft Access objects but encounters a 'no objects selected' warning.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Generating documentation for database objects like tables, queries, or reports using the built-in Database Documenter tool.
- Observed behavior
- The Documenter fails to run and displays a warning that no objects were selected, because the objects were only highlighted instead of having their selection boxes checked.
Ensure your Microsoft Access database is open, not strictly locked by another user, and you have the necessary permissions to read the design properties of the objects you intend to document.
Use Check Boxes to Select Database Objects
Resolve the error by explicitly checking the boxes next to the database objects you want to document, rather than just highlighting their names.
In Microsoft Access, simply clicking an item's name highlights it to indicate focus, but it does not mark it for batch operations. The Database Documenter requires a definitive selection via check boxes.
Navigate to the Database Tools tab on the Access ribbon and click on Database Documenter.
Click the appropriate tab (such as Tables, Queries, Forms, or Reports) in the dialog box to find the items you want to document.
Click the small check box directly to the left of each object you wish to include. Make sure a clear check mark appears inside the box.
Click OK to start the documentation process. The tool will now recognize your selected items and generate the report.

Open Objects Directly from the Navigation Pane
If your goal is to view or interact with a table or report rather than document it, ensure you are opening it directly from the main Navigation Pane.
Discover WPS Office for Your Daily Document Needs
While Microsoft Access handles complex databases, WPS Office is an exceptional free alternative for managing all your standard text documents, spreadsheets, and presentations with high compatibility and a familiar interface.
- 1. Download the Installer: Visit the official WPS Office website and download the free version tailored for your operating system.
- 2. Install WPS Office: Run the installation file and follow the simple on-screen prompts to set up the software in minutes.
- 3. Start Creating: Launch WPS Office and begin working on your documents, spreadsheets, and presentations seamlessly.

Frequently Asked Questions
Why do I get a 'no objects selected' error when my table is highlighted in blue?
Highlighting an object only brings interface focus to it. The Database Documenter specifically requires you to click the check box next to the object to confirm it for the documentation report.
How can I quickly select all database objects for documentation?
Open the Database Documenter, navigate to the desired object tab (like Tables or Queries), and click the 'Select All' button on the right side of the window to automatically check all boxes.
What information does the Access Database Documenter provide?
It generates a comprehensive printable report detailing the design, properties, relationships, fields, and permissions of your database objects, which is highly useful for troubleshooting and auditing.




