Removing "special keys" does not work!

[mafhobb]

I have just finished a database and I am getting ready to get it installed on other machines.

Before I do that, however, I want to hide the Navigation Pane as well as the full menus and "special keys". I do that by going to the options tab and removing the appropriate check marks

However, it does not seem to work! No matter how many times I do it, if I hold the shift key, the navigation pane is still there.

What am I missing here?

mafhobb

 

[John Big Booty]

Check out the code and discussion in this thread.

 

[mafhobb]

Hello John,

I have tried the two solutions posted by ghudson (one in an older 2003 version and another one more modern) and in both cases, all the user has to do is to go to the "file" menu which I don't seem to be able to hide no matter what and go to privacy options to change the database options. If he allows "Access Special Keys", then the next time he logs in, he can hold the shift key and get in.

I am struggling with this. I do not get why it is so hard to prevent a user from getting to the front end code. What am I doing wrong? What am I missing?

mafhobb

 

[John Big Booty]

Was this one of the ghudson's solutions that you looked at?

 

[John Big Booty]

This article may also help.

 

[mafhobb]

I had seen the first link. Even when using it, the menu bar remains unhidden.

I'll check the article now.

mafhobb

 

[mafhobb]

OK. #3 helped me to virtually eliminate the access special keys, however, the users can still get to the code by clicking on "design" on the "home" button of the ribbon..

How can I hide the menus/ribbons completely?

Miguel

 

[DJkarl]

OK. #3 helped me to virtually eliminate the access special keys, however, the users can still get to the code by clicking on "design" on the "home" button of the ribbon..

How can I hide the menus/ribbons completely?

Miguel

If you don't want users to see code then compile it to an MDE/ACCDE and they won't be able to enter design mode any more.

 

[mafhobb]

Is this going to make it slower? Will this also include all references?

Mafhobb

 

[DJkarl]

I've never noticed a performance hit after compiling it, it should work the same as before in regards to references. Once compiled you are no longer allowed to make changes to the code or form design, so make sure you keep a copy of the original version.

 

[mafhobb]

Yes, I'll keep a backup.

however one of my problems on this particular db has been that when the db is installed on another computer, there is a missing reference, and I do not know how to make sure that the references go with the db. I was hoping that after making the ACCDE, they would go with the file.

 

[boblarson]

Yes, I'll keep a backup.

however one of my problems on this particular db has been that when the db is installed on another computer, there is a missing reference, and I do not know how to make sure that the references go with the db. I was hoping that after making the ACCDE, they would go with the file.

Missing references are caused by the computer that the database is being run on not having the particular file that it is looking for registered. So, which reference is having a problem?

For example, if you have Excel 2007 (Excel 12.0), and your user has Excel 2003 (Excel 11.0), you will have a reference problem so in that case it is best to use late binding so you don't even set a reference and the system uses what is installed.

As for your other problem, you should be setting the Use Default Menus to NO as well as the special keys checkbox and the display nav pane as well as using the Disable Shift Bypass key code. I do it and it works quite well. If you want to get rid of the Ribbon altogether, you can create your own Ribbon using the XML like this and set it as the default Ribbon:

<customUI xmlns="[URL]http://schemas.microsoft.com/office/2006/01/customui[/URL]">
<ribbon startFromScratch="true">
</ribbon>
</customUI>

and it will just give you the option to close the database or exit Access when you do as long as the Shift Bypass key has been disabled.

 

[mafhobb]

The missing reference is "Access Image.OCX version 1.60"

How can I find what program this is part of so I can make sure it is installed on the user's machine?

mafhobb

 

[mafhobb]

Is it all about making sure that a particular dll or ocx is in a specific folder? If so, i could go to my computer, figure out what file is the one that I have to copy and then use my installer to copy it in the same location as I have it in my machine?

mafhobb

 

[boblarson]

The missing reference is "Access Image.OCX version 1.60"

How can I find what program this is part of so I can make sure it is installed on the user's machine?

mafhobb

That's one of the problems with using ActiveX controls. If it isn't installed on the target machine, it needs to be.

When you go to the references, you can sometimes find the path to get the file and then you can register it after copying to the target computer.