to place a pw on a form and VBA on Access db

[BittenApple]

Folks-
Can we place a password on the forms and VBA that nobody would be able to see the design of forms or visual basic window?
Regards,
cloudsInsky

[HansV]

You can place a password on the VBA project:
- Activate the Visual Basic Editor.
- Select Tools > ... Properties.
- Activate the Protection tab.
- Tick the check box 'Lock project for viewing'.
- Specify a strong password.
- Click OK.

To prevent users from viewing the design of forms and reports, you'd have to create a .accde database from your .accdb database. This is irreversible, so you need to keep a copy of the .accdb database. If you need to change the design, do that in your copy of the .accdb database, then create a new .accde from it, and distribute the .accde to the users.

[BittenApple]

Hello Hans,
will the task splitting of database be taken care of after I converted the database to accde?
Regards,
cloudsinsky

[HansV]

You have to split the database before converting it. You only need to convert the frontend to .accde. The backend doesn't have to be converted because it only contains tables, no forms, reports or VBA code.