>>>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.