Greg
thank you for your reply, I have tried that making a query to get the
data then making a table. Here is where I am at now.
For each location I have their foxpro table being copied into a seperat
folder (4 sites) each with thier own access data base. from those data
bases I have a make table query run, and build a table into a 5th data
base (main data base). when I open each data base seperatly and build
the table it works fine, but when I use the SQL query to to build the
table from the existing query in each database. I get the same
information from each location in the tables that are being built. Its
like it doesn't remove the fox pro table from memory when it runs the
next query. I hope this doesn't sound to confusing. On the main
database i can manualy run the query's and they work, providing i shut
down access and restart it.

Make any sense?

thank you
Warren


*** Sent via Developersdex http://www.developersdex.com ***

I have a problem with fox pro tables that are connect to access databases.
Two different locations of the same program has data files that are named
the same. I am trying to link to the two different files with access 2000
with a link to the tables. When I try to build a table using the two linked
tables. I get the data from the first table with both make table queries
unless I shut down the access database and restart it then run the second
query.

--
Thanks
Warren
warren_h@tricomp.ca