Disabled Shift bypass key but want certain users to have table /query access

[tdmailbox]

I set up my code to disable the shift bypass however for certain users
I want to allow them through a button no a form to be able open up the
list of tablies and queries.

Is there a vb command to open up the user interface that lets you view
the list of tables and queries that you would see if you did a shift
bypass?

[altacct]

You included code to re-enable the shift bypass, right? Because if not,
you won't be able to get to the database window yourself.

Assuming you did that, have a button somewhere that's only enabled for
users who are members of a certain security group, and have that button
toggle the shift bypass on and off. If a user wants to get in to the
database window, she opens the database normally, turns on the shift
key bypass, closes the databases, and opens it again, this time using
the shift key.

Jeremy Wallace

[tdmailbox]

This would work, I had thought of your idea already but was wondering
if there was an on the ffly way of allowing user to get to the main
screen without having to close and re-open the databse.

thanks..

[altacct]

Well there was, until you disabled the shift key bypass of the option
that prevents them from getting to the database window <G>

Jeremy Wallace