How to prevent users from opening database in design mode?

[abdoudiaw]

Hi,
I just finished a small Access-2013 database (accdb format).
Now I want to make it available to users.
How do I make an 'executable' (meaning that tables, forms, ... cannot be opened in design mode)?
Thanks.

 

[AlexHedley]

There should be Save As options
Choose .accde

 

[abdoudiaw]

There should be Save As options
Choose .accde

thanks for your help.
For some reason that option 'Create accde' is greyed out.

 

[Poppa Smurf]

Copy the file chnage the file extension to accdr this will open the database as a runtime version.

 

[abdoudiaw]

Copy the file chnage the file extension to accdr this will open the database as a runtime version.

IT WORKED!
Thanks a lot.

 

[missinglinq]

...What are you trying to protect against...

This is always the foremost thing to keep in mind when thinking about security! Do you simply want to prevent an employee with too much time on his or her hands from noodling around inside the file, possibly accidentally causing a problem? Are you afraid a disgruntled employee may deliberately destroy the file? Or someone from outside of the company doing the same thing?

What Access skills level are you protecting against?

...Renaming to .accdr doesn't protect anything since it is a trick that is becoming more widely known...

is certainly valid if you're talking about preventing deliberate sabotage by an Access professional. But converting to Runtime file may be all that's necessary if you're protecting against the idle noodling of a data entry person.

Once again, "What are you trying to protect against?"

Linq ;0)>

 

[haratianant]

Hi,
I just finished a small Access-2013 database (accdb format).
Now I want to make it available to users.
How do I make an 'executable' (meaning that tables, forms, ... cannot be opened in design mode)?
Thanks.

Dear friend, if you want to hide the design you can just click at Office Button on left top of the button, and then click on 'access options' click on current database, then go to 'navigation' and checkout 'display navigation pane' and checkout 'allow full menus and allow default short cuts... at Ribbon and tool bar options. Then you just close your data base and again open it would hide entire design option.
Try it

 

[bob fitz]

If you make a "accde" version, be sure to keep a copy of the original file that you use to create it. An "accde" can not be altered.

 

[CedarTree]

Hi - if the user has a full copy of Access, can't they still modify Forms / Queries in an ACCDE file? I'm able to do so... I just can't get to VBA.

 

[arnelgp]

yes, you can edit the table structure in accde unless you make the table query Invisible.

 

[theDBguy]

Hi - if the user has a full copy of Access, can't they still modify Forms / Queries in an ACCDE file? I'm able to do so... I just can't get to VBA.

Hi. Just want to clarify, modifying form design is possible but not as straightforward as with tables, queries, and macros.