Access 2007 Print Preview

[SBCUser666]

What controls what icons show in the Data group on the Print Preview ribbon?
My database has Refresh All disabled and the More option is disabled. PDF or XPS is enabled.
What I need is the More button to work and/or have Word and Excel as options. Like I see in samples from my Access 2007/2010 books.

 

[SBCUser666]

A Co-worker found the solution.
Open DB with shift key held. Go to Office Button and select Access Options. Select Current Database. Under Ribbon and Toolbar Options check Allow Full Menus.
Voila! Excel, Word, Text File and More. More has Access, XML, Snapshot and HTML.
All my high priced manuals had nada about this.

 

[Jeanette Cunningham]

Are you developing this database? I ask because those of us who develop databases for others to use, learn very early that turning off the option for full menus is necessary when restricting how users interact with the database.

My preference when developing is to have full menus allowed and only turn off full menus when distributing the database to users.

Other developers have fulll menus always disabled. They always open the database with the shift key to work on it. When they want to test how it works from the user's perspective, they open the database normally.

 

[SBCUser666]

This was an Access97 DB upconverted to 2000, then 2003, then 2007. In 97 the Word option was available in PrintPreview.

If the user is given an ACCDE then there is not much they can do if they hold the shift key. Giving them these options under Data does not seem too dangerous.

 

[Jeanette Cunningham]

I agree that the print preview options do not seem dangerous.
The reason that most developers like to 'lock up the database' by removing all default menus is to prevent users from changing any queries or editing data directly in the tables. An accde does not lock up the tables or queries.

In A2003, if we let users have the default menus, there were ways for a tinkerer (only a small percentage of users are tinkerers) to get access to the tables and queries. I assume the same applies in A2007.