Fox tables

[Warren]

I am connecting to 4 fox pro tables, at 4 different locations with one
access data base. The table names are the same and when I run a make table
query from the first table, and then run another append query from one of
the other tables. I get the same data as from the first table. If I run
the first query and then shutdown the access data base. Then restart the
database and run the second query I get the correct data from the second fox
tables.

Any one have any ideas on how I can release the table after the first query
runs? Or what might be happening here?

Thanks
Warren

 

[HoYongJi]

It is easily to do ,After run the first query,run command:use in <table name>

"Warren" <[email protected]> дÈëÓʼþ I am connecting to 4 fox pro tables, at 4 different locations with one
access data base. The table names are the same and when I run a make table
query from the first table, and then run another append query from one of
the other tables. I get the same data as from the first table. If I run
the first query and then shutdown the access data base. Then restart the
database and run the second query I get the correct data from the second fox
tables.

Any one have any ideas on how I can release the table after the first query
runs? Or what might be happening here?

Thanks
Warren