Adding Some Protection

[mxdcy]

how i can Add some sort of protection to a database so that users can not modify the stracture and the interface ?

like a password or something

thanks in advance

mxd

 

[hermanlaksko]

You could turn your database into an mde file, the program is then a compiled and locked programe. However it runs just like the mdb file

 

[Zeroanarchy]

have a look at this

http://www.weedmanager.net/access.html

and download security check.

Hope this helps

Zeroanarchy

 

[Zeroanarchy]

Add two button to a form make them invisible place them somewhere no one would look.

Private Sub Command61_Click()
Dim db As Database
Dim prp As Property
Set db = CurrentDb
Set prp = db.CreateProperty("AllowByPassKey", dbBoolean, False)
db.Properties.Append prp
MsgBox "System Lockdown, the shift key has been blocked"
DoCmd.Close
DoCmd.OpenForm "Autoexec", acNormal
End Sub



Private Sub Command62_Click()
Dim db As Database
Set db = CurrentDb
db.Properties.Delete "AllowByPassKey"
db.Properties.Refresh
MsgBox "System open, the program is currently unlocked"
DoCmd.Close
DoCmd.OpenForm "Autoexec", acNormal
End Sub


Have a good one B-)