I don't understand why you need to add them to a database but if it's working for you that way then it's not up to me.
Cetin
>hi,
>thank you for reply,it works
>
>i try to get data from my table AFM, via select somthing put all records at
>table am2,select again from afm put all records at am3,
>every time i run my form ,becuse i get this data form outside my dirctory
>
>for that i need to delete the 3 tables afm,am2 and am3 every time.
>
>thanks
>
>>>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
>>
>>
>>OPEN DATABASE e:\depstudy\mydbc1\mydbc1
>>if indbc('am2','Table')
>> DROP TABLE am2
>>endif
>>if indbc('am3','Table')
>> DROP TABLE am3
>>endif
>>
If you would drop them every time you run a form why are you adding them to a database in the first place.
>>Cetin