I have most of my data in DB2 tables which I am linking to. However, there are a few pieces of data I am gathering from text files. I put them into a little Access table and tried to JOIN with a DB2 table field. My query died....

Is Access amenable to joining different types of tables? If anyone can advise I would be most grateful!

Arpeggione

Joining data from disparate databases is well within the capabilities of Access. In fact, if the individual tables are updateable, then it is likely that the resulting query will be also. However, to perform this magic, Jet retrieves the ENTIRE DB2 (or other foreign) table so that it can perform the join locally so you really need to use this feature with care. In your case, you may be better off creating a DB2 table to hold your gathered data. You can delete and append rows to the server-side table and then join it to the main table for filtering.

your help is appreciated. In the meantime, I've decided to go another route (FOCUS) for some of this - because of the way our disparate databases are already set up.

thanks again,

Arpeggione