Securing Frontend?

[NewShoes]

Hey all,

I'd like to secure my frontend by disabling access to the linked tables, queries etc. I thought converting to .accde would do this but apparently not. Is there a way that this can be achieved?

I am aware that I can disbale the ribbons etc but they can all be turned back on using the options menu.

Any help is appreciated

-NS

 

[NewShoes]

I've been doing some reading on this and it seems I need to disable the ribbons, disable the shift-bypass key and disable the quick access keys (as F11 shows the Navigation window). Please could anyone advise on how I go about doing this?

Thanks,

-NS

 

[vanceric]

I've changed the extension to accdr which forces the application to run in runtime mode even if the user has the full version of access. Seems to do the trick for what I need.

 

[gemma-the-husky]

note that the user can just rename it back to accdb/mdb and open it normally.

you could add code to check that the name of the db does end with an r