Hi Community,
I am engaged in maintaining a Access Database. Its a Multi-User DB within a network, not so elegant I know. The scope of the db is reporting and data entry. Therefore essential is data entry and creating reports, based on this data. unfortunately from now there is no freezing option. Therefore all users starting hacking data into, even when its not allowed.
Now, I would like to develop a function, which freezes the database at a specific date. That means that absolutely nobody is allowed to entry data after a fixed date. Of course users should be able to generate reports and read the data.
May someone of you guys could help me. The function, module, script blabbla should be automatically generate the freeze, so that no manual work is to do or just pushing a button in a form.
Thanks guys in advance