sri tekukur

How to get access database

7 posts in this topic

How to get access db sync to filemaker. Every new records from access should appear or auto push into filemaker. Tq

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now