minimizing security on DB ?

[bugsy]

when i open DB (using Shift + Enter)

I only see FILE, WINDOW, HELP

for any Query design - just grid view with FILe, WINDOW, HELP again

where are TOOLS and all other choices ? How can i get them back ?

 

[Sum Guy]

It sounds like you are using the "runtime" version.

Do you have the full version of Access on your computer?

 

[bugsy]

It sounds like you are using the "runtime" version.

Do you have the full version of Access on your computer?

yep.
all other accedatabases are fine.

 

[neileg]

Try importing all the objects into a new blank database.

 

[Moniker]

If you can still get to the Immediate Window for code (press Ctrl-G), then you can type this in to perhaps get everything back to normal:

CurrentDb.Properties("AllowFullMenus") = True
CurrentDb.Properties("AllowShortcutMenus") = True
CurrentDb.Properties("AllowBuiltInToolbars") = True

(You can just copy/paste that in to the immediate window, but make sure you press return after each line.)

Save the DB, close it, and open it, and you should have full menus again. That code is the equivalent of going to Tools -> Startup and checking the three checkboxes with the names given above.