Results 1 to 2 of 2
2004-06-29, 04:39 #1
- Join Date
- Jan 2001
- Brisbane, Australia
- Thanked 0 Times in 0 Posts
Display Database Window Programatically (XP-2003/na)
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.
2004-06-29, 06:33 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Display Database Window Programatically (XP-2003/na)
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