Display Database Window Programatically (XP-2003/na)

Topic

New Reply

Is it possible to display the database window via VBA (users don’t normally see the window because of startup settings) with a designated user accessing it for maintenance purposes?

That user will have a password to display it.

Or are there other suggestions to give the ‘admin’ maintenance access.

Thanks, Leigh

Reply | Quote

Replies

If you allow the use of Access Special Keys in Tools | Startup…, anyone can unhide the database window by pressing F11.
Anyone can bypass the startup options by keeping Shift down while opening the database, unless you have used code to disable Shift as bypass key. (Search for allowbypasskey in this forum for more info.)

You can display the database window programmatically by selecting a database object (table, query, form, …) and specifying that it be displayed in the database window:

DoCmd.SelectObject acTable, “tblTest”, True

Reply | Quote

If you allow the use of Access Special Keys in Tools | Startup…, anyone can unhide the database window by pressing F11.
Anyone can bypass the startup options by keeping Shift down while opening the database, unless you have used code to disable Shift as bypass key. (Search for allowbypasskey in this forum for more info.)

You can display the database window programmatically by selecting a database object (table, query, form, …) and specifying that it be displayed in the database window:

DoCmd.SelectObject acTable, “tblTest”, True

Reply | Quote