hi,

thank you,it works.

i need to drop it if found, if not show a message
as

OPEN DATABASE e:\depstudy\mydbc1\mydbc1
SET DATABASE TO mydbc1
locate for table am2,am3
if found() 
DROP TABLE am2

DROP TABLE am3
else
= messagbox("TABLES NOT FOUND")
ENDIF

>>hi all,
>>
>>any idea ,help
>>
>>i need to drop 2 tables am2,am3 from my database(mydbc1),
>>every time i run my form.
>>

>>drop e:\depstudy\mydbc1\am2
>>drop e:\depstudy\mydbc1\am3
>>

>>
>>thanks
>
>No, that is not the way. Here it is:
>

>OPEN DATABASE e:\depstudy\mydbc1\mydbc1
>SET DATABASE TO mydbc1
>DROP TABLE am2
>DROP TABLE am3
>