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