Others

Fix Access Database Documenter Showing No Objects Selected Error

Khadija KhanKhadija Khan Oct 10, 2026 869 views

Question details

The user needs to generate documentation for Microsoft Access objects but encounters a 'no objects selected' warning.

How to Fix Access Database Documenter Showing "No Objects Selected"
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Database Documenter

Navigate to the Database Tools tab on the Access ribbon and click on Database Documenter.

2
Locate target objects

Click the appropriate tab (such as Tables, Queries, Forms, or Reports) in the dialog box to find the items you want to document.

3
Check the boxes

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.

4
Run the Documenter

Click OK to start the documentation process. The tool will now recognize your selected items and generate the report.

Use Check Boxes to Select Database Objects
Use Select All for Efficiency: If you need to document every single object within a specific tab, save time by clicking the 'Select All' button on the right side of the dialog box.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and download the free version tailored for your operating system.
  2. 2. Install WPS Office: Run the installation file and follow the simple on-screen prompts to set up the software in minutes.
  3. 3. Start Creating: Launch WPS Office and begin working on your documents, spreadsheets, and presentations seamlessly.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Free to use, significantly reducing your software subscription costs.Lightweight design ensuring fast performance on older or slower devices.Built-in PDF editing tools for comprehensive document workflows.
microsoft office alternative - wps office

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.