Stop user accessing code...

[Aubrey]

Hey all,

Is there any way of stopping the user accessing the code in my database? I've turned off all of the 'Display status bar' 'Display database window' etc so that they can't access the tables directly but the properties menu is brought up using the alt+enter shortcut so the events can all be accessed.

I expect that it is a really simple way but I'm not the best programmer!

Thanks in advance!

James Aubrey

 

[Insane_ai]

Publish the database as an MDE (2003 or earlier) or use ACCDE (access 2007)

 

[shadow9449]

Hey all,

Is there any way of stopping the user accessing the code in my database? I've turned off all of the 'Display status bar' 'Display database window' etc so that they can't access the tables directly but the properties menu is brought up using the alt+enter shortcut so the events can all be accessed.

- Press ALT + F11. This will take you to the code window.
- Go to Tools on the menu bar and then Properties
- Click the protection tab
- Click Lock project for viewing and enter a password.

SHADOW

 

[Aubrey]

Thanks a lot...all sorted now

Aubrey

 

[shadow9449]

Thanks a lot...all sorted now

Aubrey

You're welcome

SHADOW