Will you use Access to query fileMaker or FileMaker to query Access?
ODBC would seem possible, but don't know if the correct drivers are available.
If you plan to use Access to query FileMaker so you can use SQL queries, you might also investigate third party plug ins that support SQL queries of FileMaker to see if they do what you need as this may be a simpler solution with better response times.
Filemaker to query access. I have an ID database in access and what i want to do is have filemaker query that database and pull a clients picture into an container. The link between both databases would be the case number. We have a casenumber on the clients ID and a casenumber on their file.
If that doesnt work ... I might be able to change the back end of the database system from access to filemaker . Then it would be easy. However just trying to figure out whats the best way to do it.