So, some additional information. I was originally trying to push data from an MS Access query that drew from 3 linked access tables. It was failing completely. I got to wondering if it was something about the query itself that it didn't like (although, I cannot see why the ODBC would care). So, I used the original query that pulled from multiple tables and I just created a simple MS Access table. Then... I tried a very clean query that pulled data from the new query into FileMaker and IT WORKED. I have no idea why it would care wether the source data came from a single vs. multi-table append query, but it did.
So... I have a work around. But if someone has an explanation as to why, it would be helpful.
Thanks to those who read the post in an effort to help.
Thanks smc for the explanation,
Im going to try and link up FM and Access in the not so distance future, so this is Interesting. FM's ODBC driver seesm to be a little flakey, we always seem to have problems with linking FM up with Word, and I tried recently to link FM up with an Accounting package and failed.
Glad it was helpful. One of my disappointments with FileMaker is that it "doesn't play well with others". I really like the web functionality (IWP). But in a University environment, everyone has their own favorite tool of choice. it's important to be able to link and integrate will with other products. The MS products do this pretty well. Perhaps because they are all from MS, eh? If the FileMaker ODBC functionality worked better, it would be less of an issue. Maybe v10 will bring some improvements on this front.
My lesson from this whole thing was to try a few different approaches (crazy or not) before giving up. It worked out this time. Hopefully, my luck will continue.