sri tekukur Posted January 15, 2017 Share Posted January 15, 2017 How to get access db sync to filemaker. Every new records from access should appear or auto push into filemaker. Tq Link to comment Share on other sites More sharing options...
Wim Decorte Posted January 16, 2017 Share Posted January 16, 2017 You can do it from inside FM and pull, or from inside Access and push. Both platforms support ODBC so it depends on where you are most comfortable doing it from. Link to comment Share on other sites More sharing options...
sri tekukur Posted January 16, 2017 Author Share Posted January 16, 2017 hi i cant understand very well how to push from access or pull from fm. what i did is create import access data to filmaker using import record - odbc. and i need to everytime. and i try to use relationship table. result is not supported. i have try this before on mysql and it works.. can u pls describe in detail. secod is... access have a field named photo where the pic saved and when i import record the pic export to container... result is 'untitled dat' thanks in advance MyKadData.zip Link to comment Share on other sites More sharing options...
MonkeybreadSoftware Posted January 16, 2017 Share Posted January 16, 2017 Alternatively you can use MBS Plugin and connect to access database regularly in a script to move all new records yourself. see http://www.monkeybreadsoftware.de/filemaker/ 1 Link to comment Share on other sites More sharing options...
Wim Decorte Posted January 16, 2017 Share Posted January 16, 2017 10 hours ago, sri tekukur said: hi what i did is create import access data to filmaker using import record - odbc. That is the right way to do it if you want to pull from FM. Does the import work at all? If not what is the error message? 10 hours ago, sri tekukur said: hi . and i need to everytime. and i try to use relationship table. result is not supported. This I do not understand. "Everytime" -> are you saying that you do the import manually and want to automate it? If so you need to build a script that does the import for you. "I try to use relationship table" --> that doesn't make sense based on what you have already described. Are you trying to use the FM ESS feature (instead of the Import feature)? If you are trying to use ESS then it will not work. Access is not a supported ESS data source. Link to comment Share on other sites More sharing options...
sri tekukur Posted January 16, 2017 Author Share Posted January 16, 2017 I already write a script importing data from access. What i need is only the current record from access db to my fm solution..every time i hit the import recod script and all the records in access goes to fm. Can we specify in script that only the certain records goes to fm. tqvm Link to comment Share on other sites More sharing options...
Wim Decorte Posted January 16, 2017 Share Posted January 16, 2017 You can define a SQL query in the FM import script step to isolate the record(s) you want: http://www.filemaker.com/help/13/fmp/en/html/odbc_ess.20.13.html If that is not easy to do from the FM side then you may need to push the data from Access to FM through FM's ODBC interface. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2648 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now