Hi all

I have inherited a FileMaker 4 database which I need to interrogate using a
custom Visual Basic 6 application. I have previously used ADO from within
the VB app to issue SQL queries to my Access databases. Can I do the same
with a Filemaker 4 database? If so, could someone point me in the direction
of the relevant conneciton strings, etc?

Alternatively, I've come across a few mentions of ActiveX components and
other methods for doing this. I'd prefer an SQL route if possible, but I'm
open to suggestions.

Many thanks,

Stuart

As far as I know VB can NOT talk to FileMaker 4 directly. Trying to
accomplish this with ActiveX is also a joke.

If you can't or don't want to use FM4 instead of VB then the only
potential solution I can offer is to export the data out of FileMaker
and import it into Access. The export can be scripted, so users can
still use FM to enter the data, and every night you could repopulate
Access with the latest data.