Hola João, Como estás hoje?

Is the data in the categorias and terceiros tables used elsewhere? In other words can you use cursors instead?

Close Tables All does not close any open database. Is it possible that the DBC has been opened during the form methods? If so it would be opened exclusively and may be blocking VFP from opening tables shared. Try "Close Data All" instead.

You might also try opening the individual tables exclusively leaving the "SET EXCLUSIVE" value to OFF.


Espero ter ajudado
Barbara


>Hi, all
>
>I have in DE 1 DBC and 4 tables, in my form i need to have a buttom to import some data from outlook, i need to close 2 tables (categories and contacts) to zap, and then import the data, the problem is that, what is the way to reopen the tables?
>
>my code,
>

with thisform
>	close tables all
>	set exclusive on
>	use  categories
>
>	zap
>	.getcategories()
>	
>	use terceiros
>	zap
>	c_cat='ALL'
>	.findcontacts(allt(c_Cat))
>	close tables all
>
>	set exclusive off
>	
>	use categorias shared	---> Cannot access table
>	use terceiros shared
>	select categorias
>

>
>Thank's in advance
>
>João Batista