Kobotoolbox and MS access

[CalebTek]

I want to use Microsoft Access and Kobotoolbox to develop a Bio ID card system. The objective of this project is to create a comprehensive solution that seamlessly integrates data from Kobotoolbox into Microsoft Access, generating Bio ID cards with auto-generated photos retrieved from the Kobotoolbox server

[Kal_Lam]

Welcome to the community, @CalebTek! FYR:

Kobokollect and MS access

Hi @Latoyaaj, Welcome to the community! Don’t know exactly if KoBoToolbox can be connected with MS Access. Looking at the discussion that has happened in the past (it seems impossible): But we do have support articles on how KoBoToolbox can be linked with MS Excel and Power Bi. Maybe these support article should provide you some hints if it’s possible to connect. Kindly please do share your findings with the community (if you are able to share) as a large number of users should be benefit…

However, let’s see if our valued users have any workaround.

[mdarshad17]

Hi @CalebTek,
Adding with @Kal_Lam, You can also try the below diagram. Because MS Access can import data from Excel and you have to Link the MS Excel table with MS Access. So whenever the Excel data will be updated from the Kobo server, the MS Access database will also be updated the MS Excel data. Your main data source for the MS Access will be the MS Excel data file. You can try, hope it will work. Regards,

[CalebTek]

Hello, @mdarshad17
This is incredibly helpful, and I’ll use the diagram and let you know how it turns out.

Regards

[Kal_Lam]

@mdarshad17,