Enable design view of objects programmatically

[PRMiller2]

I have found this before, but 2 hours of Googling have so far been unsuccessful.

I have a database in which I cannot view any object in design view. For example, right-clicking on the name of a table does not bring up the usual menu for allowing me to select design view. I can create a new table in design view, but once I close it, I can no longer open it in design view.

When I do create a new table in design view, I am also unable to right-click to view properties.

I have seen code before to loop through tabledefs and/or objects to allow design view, but I can't seem to find it (should have saved it, I know). Any suggestions?

 

[dhookom]

Does this happen for all Access files?
Have you checked the Options for the Current Database?
Can you get any shortcut menus to display?


Duane
Hook'D on Access
MS Access MVP

 

[PRMiller2]

Ah, figured it out: while design changes were allowed, I must have removed the option to Allow Default Shorecut Menus. Placing the check back there allowed me to view in Design View.

Wow, that was bad. Thanks for the pointer, Duane!