Integrate ODK with MS ACCESS

Hi

I would like to know if it's possible to integrate ODK with MS ACCESS, creating a command like to push data from ODK Cloud to ACCESS tables to create customized reports?

There is nothing turn-key that I know of, so you'll likely have to
write some code.

https://opendatakit.org/use/aggregate/data-transfer/ lays out some of
your options.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Fri, Mar 11, 2016 at 3:19 PM, nordinotitus.mz@gmail.com wrote:

Hi

I would like to know if it's possible to integrate ODK with MS ACCESS, creating a command like to push data from ODK Cloud to ACCESS tables to create customized reports?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

what I did for similar scenario

  1. I installed MYSQL as back-end for ODK collect
  2. I installed ODBC drivers
  3. I configured ms access as front end with links to MYSQL database
    That way u can do yo reports in ms access
··· On 14 March 2016 at 09:17, Yaw Anokwa wrote:

There is nothing turn-key that I know of, so you'll likely have to
write some code.

https://opendatakit.org/use/aggregate/data-transfer/ lays out some of
your options.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Fri, Mar 11, 2016 at 3:19 PM, nordinotitus.mz@gmail.com wrote:

Hi

I would like to know if it's possible to integrate ODK with MS ACCESS,
creating a command like to push data from ODK Cloud to ACCESS tables to
create customized reports?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
**In sun set years education is not associated with standard of living and
medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 / 0703516660
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

From what I interpreted the link is supposed to be on access and an aggregate hosted in the cloud and not a locally installed one .The one you did I always do it even for editing but you have to create a composite primary key on the tables to make sure you have a good primary key for the linked table