Really Slow ODBC speed

[Eric PVG]

Hello, this is my first post.

I'm using FMP as a data source for MS Word mail merge. It wasn't easy, but I did get the ODBC link to connect and I can (enventually) get a list of FMP fields to insert into my document. The trouble is that the connection seems REALLY slow, and this is just a one-table test DB with ten records that's on my desktop. Waits of 2 minutes to connect are happening, with 10 seconds or more to move between previewed records! Is there any sort of connection issue that I am probably overlooking? MS Word shows to be running a process of 155 Megs. when the Filemaker DB is connected, which seems really high. There must be some big processing overhead going on that must be able to be prevented somehow. Any Ideas? Thanks in Advance!

E.V.

[mr_vodka]

Hi Eric,

What kind of system specs are you working with here?

[Eric PVG]

Thanks for your response. We figured out a great workaround yesterday. Word doesn't seem to play well with FMP but Excel gets along OK. Using an ODBC connection from FMP to Excel, and then pasting a link from the Excel cell into Word works really well. We were using an Excel SS to populate some other text in our Word documents anyway, and these little queries that Excel can do on FMP allow us to pull from our live data in real time, which is exactly what we wanted to do.