*snip*
>>>However... I think a user can modify the table and remove the trigger right?
>>
>>Only if they can get exclusive use of it.
>
>That would be very easy with a copy of VFP wouldn't it? Assuming no one else had it open?
If you are looking to implement security, you could use something like Cryptor to encrypt the tables.
You could also set up file level security at the OS level. Only give access to certain accounts. Create a data access object that creates a connection to that directory using WNetAddConnection2 (see Ed Rauh's NETRESOURCE entry in the Files section) or Network object of the Windows Scripting Host. Both allow you to specify a user name and password for connection purposes. Once the connection is made, you can use methods of the data object to pass updates through.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao