aviod shift enter

[!]

Is there any method the aviod user editing the mdb by pressing shift +
enter?
thanks

 

[Douglas J. Steele]

You need to create and set a database property AllowBypassKey.

Check http://www.mvps.org/access/general/gen0040.htm for the correct way to
create this property.

Once you've copied MichKa's code into a module, you can call it as

ChangePropertyDdl "AllowBypassKey", dbBoolean, False, True

Note that this won't take effect until the next time you open the database.
Note, too, that you don't need to save the module containing MichKa's code:
once you've set the property, you shouldn't need that code in that database
again.

Do this on a copy of your database, just in case you have occasion to use
the Shift key yourself someday!

 

[Larry Daugherty]

Convert a copy into an MDE file, keep a copy of the MDB because you can't
alter the MDE, to make changes you change the MDB and create a new copy of
the MDE.

HTH