Link to home
Create AccountLog in
Avatar of alevin16
alevin16Flag for United States of America

asked on

I want to keep people from accessing design view of a form in MS Access

I have MS Access 32 bit.  I created a program for a company but they have 64 bit Office. I tested running the program as an accdb and it worked fine.  The problem is I do not want them to be able to right click and get to design view and also not be able to hold the shift key down on startup and get to design view.  I think I know how to disable design view with the right click but can I disable the Shift at startup?  I tried converting the accdb into an accde but because i have 32 bit it will not run on their systems as an accde

Avatar of Bitsqueezer
Bitsqueezer
Flag of Germany image

Hi,

the only chance to disable design view is to use an ACCDE. So if they have 64bit Office I'm afraid you need to compile it to ACCDE on their Office. For that you can copy your ACCDB on a computer with 64Bit office, compile it to ACCDE and then deliver this one.

Please make sure that you adapt Windows API calls to 64Bit if you use such.

For disabling Shift key MS itself has published a tutorial:
https://learn.microsoft.com/en-us/office/troubleshoot/access/disable-database-startup-options

Cheers,

Christian
Avatar of alevin16

ASKER

Hi Christian

This is very helpful!  I am going to try disabling the shift key from the code you connected to.  A long time ago I thought I disabled design view with a VBA command?  Is there no such command?

Thanks
Andy
Hi Andy,

not that I would know off - and if (like the shift key) it would be easy to get it back working. ACCDE is in opposite a way to disable design as only the compiled code is available, the design stuff is completely removed, so no way to look into it.

I would never deploy a frontend without compiling it to ACCDE...;)

By the way: You can use ACCDE also with an Access runtime which costs no licence fee, if you want to deliver it to anybody without Office licence. Moreover, you could install a 32bit version on a Terminal Server and use a RemoteApp (not RemoteDesktop although also possible) to deploy it to users. For the user it looks like a locally installed application (except that they get a login screen from the Terminal Server) and they don't need to change the 64Bit Office and you can go on using the 32Bit version as it only needs to be installed on the Terminal Server.

Cheers,

Christian
To prevent users from accessing Design view of a form in MS Access, you can set a password for the form. Here are the steps:

Open the form in Design view in Microsoft Access.
Click on the "Form Design" tab in the ribbon.
Click on the "Property Sheet" button in the "Show/Hide" group.
In the "Property Sheet" window, select the "Other" tab.
In the "Password" field, enter a password that you want to use to protect the form.
Click "Save" to save the form with the password protection.
Close the form.
Now, when users try to open the form in Design view, they will be prompted to enter the password. Without the correct password, they will not be able to access Design view or make any changes to the form's design
Hi Partha,

maybe it's a brand new Access feature I don't know but I am not aware of any "Password" property in an Access form.
Have you a screenshot of that feature and the Access version you use?

Cheers,

Christian
Hey Partha,

I am not seeing that.  It sounds like a great idea but I did not see it in the Other tab or even the all tab.

If you have more information I would love to hear it.

THanks
Andy
n older versions of Access, such as Access 2003 and earlier, you can still password-protect a form, but the process is slightly different. Here are the steps:

Open the form in Design view.
Click on "Tools" in the menu bar, and then click on "Properties" (or press F4).
In the "Properties" window, select the "Protection" tab.
Check the box next to "Use a password to lock/unlock the form".
Enter a password in the "Password" and "Verify" fields.
Click "OK" to close the Properties window.
Hi Partha,

I've never seen any password protection for forms in all the years of working with Access.
At the moment I have A2013 here and it has no password option.

Cheers,

Christian
Hi Partha,

I am using Access 2016.  Do you have any screenshots showing where it is?  I would love to do this.

Andy
Hey Christian

I tried the link you sent me about disabling the SHIFT on startup.  I have never done this so I am a little clueless on it.  Do I run it once form the intermediate window and from that point forward it will always be set or do I have to run it ever time the program opens.  

I need something that I can set once and then save it in that state so I can then distribute the program

Also I found the code I had before, it was just Form.ShortcutMenu = False.  This shuts off the right click on the forms.

Thanks
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Disabling things with code and/or settings will not stop me creating a new Access database and importing all the objects.  I then have a copy of everything to do with what I want.

The only way to fully protect it that I know of is with a accde.

ASKER CERTIFIED SOLUTION
Avatar of Bitsqueezer
Bitsqueezer
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account