Is there any way to lock my database's design view with a password? If possible, I do not want to have to create a separate MDE file or encrypt the entire database with a password.
Thanks!
Is there any way to lock my database's design view with a password? If possible, I do not want to have to create a separate MDE file or encrypt the entire database with a password.
Thanks!
Why is this necessary? If you don't use the database password encryption then that means using VBA code and code can be bypassed by holding down the shift key when database opens, unless you want to disable the shift bypass, which is more password coding. As with any password implementation, forget the password and the db is likely unrecoverable.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.