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
to place a pw on a form and VBA on Access db
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: to place a pw on a form and VBA on Access db
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.
- 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.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: to place a pw on a form and VBA on Access db
Hello Hans,
will the task splitting of database be taken care of after I converted the database to accde?
Regards,
cloudsinsky
will the task splitting of database be taken care of after I converted the database to accde?
Regards,
cloudsinsky
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: to place a pw on a form and VBA on Access db
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.
Best wishes,
Hans
Hans