Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MS Access - RIght-Click on object is disabled

Tags:

vba

ms-access

I have recently taken a job that involves using an Access database to find information. The database in question was built by a developer who left before it was completed. He also didn't leave any documentation behind.

The database uses queries, forms, and VBA. Some of the queries are no longer valid since the source data has a different format than what it was when the database was developed. I know SQL and some basic VBA so I'm trying to modify the SQL; however, I cannot view the SQL behind the queries. I can't open it in Design View or SQL View. I can't even right-click on any object. Not only that but when I open an object, I can't right click on the top tab to close it. There's a red x that populates on the top-right that I have to use. I've tried holding shift when opening the DB, but it still happens. I also went to: menu option Tools -> Startup -> to see if 'Allow Default ShortCut Menus' was unchecked; however, it wasn't. I've checked other forums but haven't been able to find a solution. I think it may be in the VBA somewhere but there are tons of modules and each module has a boat-load of sub procedures in it. I have no idea what else it could be. Any and all insight would be greatly appreciated!

like image 527
48_million Avatar asked Nov 09 '22 09:11

48_million


1 Answers

@Andre and @Comintern both provided correct answers. The culprit was in the Auto Exec function and it had a loop that went through each CommandBar and set Enabled = False.

like image 50
48_million Avatar answered Nov 15 '22 06:11

48_million