preventing File->open ....

[Brad Pears]

I want to make sure that users cannot use the 'File->Open options to open
any other db's etc..' How can you remove the file->open option from the
app?

Thanks,

Brad

 

[Rick Brandt]

I want to make sure that users cannot use the 'File->Open options to
open any other db's etc..' How can you remove the file->open option
from the app?

Thanks,

Brad

This is basically like saying "I want to create a Word document that will
prevent the user from being able to open any other Word documents." While
you can give your users a file where this menu is not shown all they would
have to do is open Access without opening your file so I fail to see what is
accomplished.

Generally the way to control the Menu bars and Tool bars is to supply custom
ones for your app and uncheck "Allow built in tool bars" in the Startup
menu.

 

[Brad Pears]

I probably should have elaborated on this as it does sound a littel odd...

The background is that this user dials in remotely using a terminal services
session. In the AD account for this user, we are automatically launching the
ONLY Access app we want the user to run. They do not even get a desktop.
Problem is, if you click cancel on the Access username/password screen, you
simply sit at a blank Access screen on which the user could use file open
and browse to other locations on your drive and possibly gain access to
something they should not be able to... Typically we have access set up by
group etc... but there are instances where the "everyone group" may have
read rights to a dir etc... In the event that a user does cancel the logon
and gets the blank screen, I just would like to have it so that they cannot
browse and open anything else up...

Best would be that if they do cancel the logon screen presented by Access
for whatever reason, that MS Access is just exited altogether. I wonder if
that's an option?? That would solve the issue!

Thanks, Brad

 

[Paul Overway]

Set the options in Tools|Startup, create a custom menu/toolbar with
appropriate options, and open Access with the /runtime switch,