deployment problems 2

[joeblow3]

HiAccess 2003)

I split my application into the database part and the front-end. Then I made an mde out of my front-end. Now, when I look at the database window (when I open the mde): for the Forms and Reports the "Design" and "New" icons are greyed out. However this is not so for Tables and Queries. The user can modify my tables and queries.

I want so that users should not be able to make changes to my application when the mde is deployed to their machines.

How can I achieve this and what is the reason that the greyying out is done for some and not for all.

Thanks in advance.

 

[KornGeek]

In short, the reason the forms and reports are disabled is that in an mde, the vba code is compiled and cannot be edited. Thus, forms and reports (which have VBA modules) cannot be created or modified. However, tables and queries do not tie directly to VBA and can still be edited.

As far as how to prevent that, you want to look into Access security. It's a complex topic to learn, but there are many here who can help.

I'd offer more, but I'm a little pressed for time at the moment. Perhaps somebody else can offer advice on how to secure the mde.

 

[Chelsea7]

Hi JoeBlow3,

Did you set up user accounts for the people using it? If you did, you can set the permissions so that they can't modify the Tables or Queries. By default, the two group accounts are Admin and Users. It's best practice to assign the permissions to the group here the Users group but you may want to create a specific group name (i.e. Staff). Then after you create the user accounts for the people using it, assign them to that group. You can use the security wizard located under Tools >Security menu.