You could use SYS(16). If it returns an empty string you are in the Development Environment. Otherwise it returns the name of the currently running executable.

>Txs for all the answers
>
>but how can i check if the table is opened from vfp or from my application.in short how can i identify in which environment am i in, dev or prod ?
>
>Txs
>
>>Check out the database events. You can put code in the DBC that will only allow tables to be opend if a certian condition exists, such as a global variable you create and initialize at the beginning of your program.
>>
>>>Hello all
>>>
>>>How can i restrict the user from getting to the database from foxpro,i want them to use the application to make any changes.
>>>
>>>txs