H
Henrootje
I would like to make ALL objects in my database invisible, can anyone
think of code to do this automatically?
TIA Henro
think of code to do this automatically?
TIA Henro
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Hi Henro,
Rather than making all objects invisible, have you considered using the
Tools > Startup... options to deselect "Display Database Window" and "Use
Access Special Keys"? Disabling special keys will prevent a user from
pressing F11 to display the database window. (Side note: It will also prevent
you from stepping through VBA code with a break point set).
You can take it a step further by disabling the Shift Key, so that users
cannot bypass your startup settings. And, if really needed, you can even
implement Access Security to secure the AllowByPassKey. More details on this
here:
Securing AllowBypassKey
http://www.mvps.org/access/general/gen0040.htm
This just seems a lot easier than trying to hide all objects, which really
isn't going to fool someone who is intent on digging into your database. To
prevent changes to forms, reports and modules, you can create a .mde file.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I would like to make ALL objects in my database invisible, can anyone
think of code to do this automatically?
TIA Henro
Rather than making all objects invisible, have you considered using the
Tools > Startup... options to deselect "Display Database Window" and "Use
Access Special Keys"? Disabling special keys will prevent a user from
pressing F11 to display the database window. (Side note: It will also prevent
you from stepping through VBA code with a break point set).
You can take it a step further by disabling the Shift Key, so that users
cannot bypass your startup settings. And, if really needed, you can even
implement Access Security to secure the AllowByPassKey. More details on this
here:
Securing AllowBypassKey
http://www.mvps.org/access/general/gen0040.htm
This just seems a lot easier than trying to hide all objects, which really
isn't going to fool someone who is intent on digging into your database. To
prevent changes to forms, reports and modules, you can create a .mde file.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I would like to make ALL objects in my database invisible, can anyone
think of code to do this automatically?
TIA Henro
G
GAVO-UK
Make sure to create a back up of you application before disabling
Special Keys; you don't want to be locked out of your own app.
GAVO.
Special Keys; you don't want to be locked out of your own app.
GAVO.
G
Guest
Hi Gavo,
I think that warning is more appropriately stated as "Make sure to save the
source .mdb file after converting to .mde". You (or anyone) can easily
re-enable Special Keys. If you implement Access Security to prevent changes
to the AllowByPassKey, you will make it harder, although not impossible, for
others to change this setting. As the Admin of a database, you should still
be able to reset this property.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
Make sure to create a back up of you application before disabling
Special Keys; you don't want to be locked out of your own app.
GAVO.
I think that warning is more appropriately stated as "Make sure to save the
source .mdb file after converting to .mde". You (or anyone) can easily
re-enable Special Keys. If you implement Access Security to prevent changes
to the AllowByPassKey, you will make it harder, although not impossible, for
others to change this setting. As the Admin of a database, you should still
be able to reset this property.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
Make sure to create a back up of you application before disabling
Special Keys; you don't want to be locked out of your own app.
GAVO.