Security

[csdrex87]

So I want to put in some code to restrict the user from pulling up anything other than the initial Login screen. Currently that form is the formUserLogin and is set to be loaded on startup. Does anyone know a way to write code to either loop the focus onto the login form or if they open anything else to automatically do a Docmd.Quit?

 

[HiTechCoach]

Try setting the formUserLogin form's property for Modal to yes. See if that gets you what you want.

 

[csdrex87]

Thanks worked like a charm!

 

[HiTechCoach]

Glad that worked for you!

 

[KenHigg]

Seems there could still be issues if that's all you do Boyd - ?

 

[HiTechCoach]

Seems there could still be issues if that's all you do Boyd - ?

Ken

I agree with you that this is not all that needs to be done if you are trying to lock done the database.

I like to disable the shift bypass key. I also only use an MDE/ACCDE as the front end that also checks to see if the runtime mode is being used. If not, then closes.

 

[mcdhappy80]

Ken

I agree with you that this is not all that needs to be done if you are trying to lock done the database.

I like to disable the shift bypass key. I also only use an MDE/ACCDE as the front end that also checks to see if the runtime mode is being used. If not, then closes.

I tried using this code http://www.access-programmers.co.uk/forums/showthread.php?t=177441&highlight=disable+shift but it doesn't work in my database. Do You maybe have some other code or am I doing something wrong here?
How do You check if runtime mode is being used?

Thank You
================

I've found other code (also thanks to this forum posts) http://support.microsoft.com/kb/826765 that worked for me.