I've been trying, and get the same indexing error.

I did not receive any replies to my recent posts regarding this indexing error when using MS-Access to connect to FMPro via ODBC. The only thing I can tell you is that it seems to fail if there are more than 32 fields in the FMPro database. MS-Query doesn't have this problem, so that is what I've ended up using (note that MS-Excel uses MS-Query to get data from other sources).

This "fix" isn't elegant, and it isn't live (i.e. when I want to run my reports I need to update the MS-Excel spreadsheet which is linked to the FMPro database), but, at least for my purposes, it gets the job done.

I got around the problem (can't say that I solved it) by creating a duplicate FMP data base, and doing an import from the original of only the files needed by MS access. I then set up a script to delete all the files in my 'duplicate' and automate the import.

Ron Filipek