>We have an application that looks at data from multiple locations. The different sets of data have all the same files, but not necessarily the same structures. There is a "COMMON" directory that is used as base data for the application. That data typically has the most recent structures in it, and also is where the database is opened from. All of the other sets of data also belong to a database, and when a file is opened multiple times with different names I get an error if the structure doesn't match the database that is open. Is there a way around this, or should I just look at a different way of approaching the situation.

I'm not sure I understand the question, but in general you shouldn't have tables of the same name with different structures, and you should'nt have the same structures with different names. If you mean you are trying to open a table with a different alias you can USE table AGAIN IN 0 or something similar.

If your tables are generated on the fly with an previously unknown structure, then try using a system generated filename and keep track those in another lookup table.