Accessing filemaker data from another application - eg. VBA using a DSN
I can pull out filemaker data in a VBA program using a DSN. But I can't manager to change it - i.e update a value and return it to the filemaker table. I've set the security to allow anything and the ODBC guide says you can update. Has anyone got an example of code that works ? Interestingly I can link to a filemaker table in MS Access and display the data but I'm prevented from updating. Which makes me think there is some setting in Filemaker which prevents changing table data.
Any help much appreciated.... !