startup properties in Access  
Author Message
Dani50





PostPosted: Visual Basic for Applications (VBA), startup properties in Access Top

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 Forums2  
 
 
Derek Smyth





PostPosted: Visual Basic for Applications (VBA), startup properties in Access Top

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.



 
 
Dani50





PostPosted: Visual Basic for Applications (VBA), startup properties in Access Top

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