November 20, 200718 yr FM 8.5A , all on Windows XP Home/Professional We have a customer who need a local copy of our main Customer database on their company laptops. The database consists of about 12 tables across 3 files, approx 125 MB in total. We need to look at the hypothetical possibility of a internal staff taking a copy of our Customer database and sell to another company. What is the best way to lock the database so it cannot be copied, or cannot be run on a non-approved machine. Thanks, :)
November 20, 200718 yr Essentially there is no way to assure that the data cannot be taken and sold to another company. You can make it challenging to do, but you cannot guarantee that a user who otherwise has access rights to view the data will be prevented from taking it. Steven
January 19, 200817 yr can you lock records after a period of time so they cannot be altered ? Edited January 19, 200817 yr by Guest
January 19, 200817 yr Yes you can lock records after a fixed period of time, using Record Level Access tests. Steven
Create an account or sign in to comment