I make a database with tables, queries, forms and reports.
I would like write cod who will block enter data after one year but I do not
know how.
I would like write cod who will block enter data after one year but I do not
know how.
-
-
Putting a timelock on a database can be used in two ways:
One to protect copyrights, but also to set a "time bomb"....
Be sure there's no way yet to do this 100% "foolproof" . Every code used to protect a database can be hacked and some protection will be more hard to crack than other, but there's always a way around it.
Nic;o) -
This is all off the top of my head; haven't tested any of it, but here's some general ideas. This is based on using the form's Tag property.
First you'd need to make the database an MDE file so that the end user would have no access to the code.
You'd have to limit the user's access to forms only! No direct access to queries or tables.
Set the Tag property of each form to your desried cutoff date.
Then use this in each table.
Next you'd have to use this in
[CODE=vb]Private Sub Form_Load()
If Date > Me.Tag Then
Me.AllowEdits = False
Me.AllowAdditio ns = False
Me.AllowDeletio ns = False
End If
End Sub[/CODE]
As Nic;o) said, this can be beaten! But it'll make it harder to do.
Linq ;0)>Comment
-
I want enforce monthly or yearly MsAccess application license renewalOriginally posted by nico5038Comment
-
Best then to start with the legal side of the license. Additionally a good service and regular updates to keep your customers satisfied will be as important as a "technical" lock on the application.
You could try to use Internet to exchange a licensekey and I'm sure there will be third parties on the web offering possibilities for this.
For indept security you could check this book:
Nic;o)Comment
Comment