What Is The Best Way To Lock Down the Database ?

[dicksonlim88]

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, :)

[Steven H. Blackwell]

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

[redballoon]

can you lock records after a period of time so they cannot be altered ?

Edited January 19, 2008 by Guest

[Steven H. Blackwell]

Yes you can lock records after a fixed period of time, using Record Level Access tests.

Steven