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.
startup properties in Access
Hot Topic
- Referencing unregistered DLL
- Updating text in a text box on an Excel Graph
- Memory profilers
- Textbox won't keep new values after workbook closed
- Limit Macro to current workbook
- add table to a word document
- PASSING MS OUTLOOK DATA TO EXCEL
- ComboBox: VBCode to select first item in the list.
- Hyperlink in text (or anywhere)
- How to pop data from a table in MS Access 2003?
Microsoft ISV
- Office 2003 and 2007 Primary Interop Assemblies (PIAs)
- Can't open regedit
- RecordSet problem
- Restrict editing of activity based on date comparison
- Select Syntax problem in a Query
- autocomplete
- Unable to access the System Settings and Reports areas in a new CRM 3.0 installation
- Paste Charts to Word in VB.Net
- variable declarations
- using dll file
startup properties in Access
killfr0g
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
Tushar M
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.