startup properties in Access

I want to prevent others from changing the startup properties using VBA in another access file. I don't use User level security because I am not in a position to prevent either the database file being copied onto another machine or a workgroup file from being over written. In either of these cases I find the owner becomes unknown. There is a password on the VBA code.

Microsoft ISV Community Center Forums1

Hi Dani,

Bit of a late reply, yes you can password protect your VBA code.

In the VBA Editor in the Solution Explorer if you right click the top most node for your project and select properties a dialog box appears, on one of these tabs you'll see a place where you can enter a password. Tick the 'lock project for viewing' to enable the password.

Hope that helps, better late than never.

Hi Derek,

Thanks for the reply. I do already have a password on the code. If I try and insert a form from another database it asks for a password, but I can change the startup properties from inside another database without the password being asked for. I have just checked it again in case I made a mistake.

Dani