>>>>If I set up a write trigger to prevent someone from changing data in my app, can it be bypassed?
>>>>
>>>>I envision having the trigger look for some global var before it will work. If the table is opened indepedently
>>>>of the dbc will the trigger still work?
>>>
>>>Once a table is associated with a database, when you open the table, you open the database. The triggers will fire.
>>>
>>>FWIW, you can check this out by opening a table and then checking the return value of DBUsed("MyDatabase"). The database is open; however, it is not the current database. To make it current, you need to SET DATABASE TO MyDatabase.
>>
>>Nevermind... I never knew the difference between INSERT and INSERT SQL.
>>
>>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?