Disable the F4 key in ACCDE

[fitshase]

I've created a database and I distribute the front end using the ACCDE format. One of the forms I have is set to open Read Only and I have disabled editing, deleting, etc., in the property sheet.

However, when I create the ACCDE I hit a problem. On opening the ACCDE file, I click the button to open the form and all works well. However, I can press F4 and it shows the Property Sheet where I can change values to allow editing.

Is there any way to disable the property sheet in the ACCDE file?

Cheers

 

[vbaInet]

Use the Key Down event of each form and report. Check the KeyCode against the F4 keycode and set it to 0 if it's F4.

 

[boblarson]

Are you absolutely sure you have created an ACCDE file? It should not be even possible to get anything with design implications from an ACCDE file since it is compiled and such. This is something that I need to test because it should not be possible at all once the database has been changed to an ACCDE file.

When you create the ACCDE file, do you close the ACCDB file and then go open the ACCDE file? Or are you just using the file that has reopened for you? It reopens to the ACCDB file, not the ACCDE file. You have to go open that manually after creating it.

 

[vbaInet]

It should not be even possible to get anything with design implications from an ACCDE file since it is compiled and such.

Good point Bob. It didn't even click

 

[fitshase]

Good point Bob. It didn't even click

Doh! I didn't even click either! I thought it opened the ACCDE file when it created it.

I can rest easy now and release the version.

Cheers

 

[boblarson]

Glad to hear that it wasn't doing things it shouldn't have. But believe me, I've done things like that before, so no worries.