var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access 2007 - can't modify query
I have an Access 2007 database that is locked somehow. I was able to display the navigation pane, but if I try to modify a query, I can't open the design window. I right click on the query and no options display. I just upgraded to 2007 and I'm still getting up to speed. How do I unlock this?
Select Access Options from Office Menu (left top corner). Find options under Ribbon and Toolbar Options. Check whether check-marks are already there in all the following three options:
Allow Full Menus Allow Default Shortcut Menus Allow Builtin Toolbars
Put check-marks in missing cases. Close the database and Open and it again. Right-click on the Query to display the short-cut menu
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007
I have a similar issue, but this time the Access Options selection is not visible in the MS Office button. How do I unhide this?
Found it elsewhere on the web...
I was holding the shift key while opening the mdb file, but you have to hold it down until the file is completely open.