Solved: How to block users from changing the Access Design?

[winxmun]

Anybody can help me on how to block users from changing Access design? Example, block users from using Shift+Enter to open an Access file. Thank you in advance.

[Oorang]

http://www.databasedev.co.uk/disable_shift_bypass.html

[winxmun]

Hi Oorang, tks for your reply. i've just tried the method but encounterred error msg, ie Syntax error. Any idea why?

My access file was created with startup option to open a form called fmStartup. In the code sample, i've to create a module & a command button. i've created the module but not sure where to create & attach the code to a command button?

May i know where to create the function & code to a command button?
Where to create the command button, in a form?

Actually i tried to create the common button in the fmStartUp form but was prompted with the error msg, ie Syntax error. Any idea what's the reason?

Tks & regards

[winxmun]

Hi Oorang, i have tried using the method in the hyperlink provided . However the function is successful. I have attached the access file for your assistance. Thank you very much....:help

regards,
winxmun

[icthus123]

Can't you just split it and convert the front end to an MDE database? That should stop users from changing things.

[Oorang]

Should be just a one liner from the immediate window:

CurrentDb.Properties.Append CurrentDb.CreateProperty("AllowBypassKey", dbBoolean, False, True)

[winxmun]

Previously not very familiar with converting of MDB to MDE. Now have tried converted a file so will be trying to convert the rest to MDE.

[Oorang]

Make sure you keep track of the original.

[winxmun]

yup! tks for the reminder...:thumb