Rob Koelmans
My feedback
-
179 votes8 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
We have presented in a recent user group session about an investment we are making in building a CDS Connector within the Access application, to successfully move your data to and from CDS; which will power a variety of Power App and MS Flow applications.
Check out the presentation here https://www.youtube.com/watch?v=x_o3F89EcBI, and scroll to the latter half of this video to hear more about CDS/Power Apps.An error occurred while saving the comment An error occurred while saving the comment Rob Koelmans
commented
Hi Anders,
Essentially I'm asking for a webservice optionally installed along with MS-Access that enables a webservice client to do everything a human could do with an Access Application (so, start MS-Access instance, load adm/accdb, use user-defined-functions/procedures/macros, open forms/reports, read/write form/report controls, trigger events or effectively equivalent).An error occurred while saving the comment Rob Koelmans
commented
This would also enable Flow to perform scheduled jobs in a MS-Access application. A MS-Word/Excel like macro recorder would top it off.
Rob Koelmans
shared this idea
·
-
76 votesRob Koelmans
supported this idea
·
-
50 votesRob Koelmans
supported this idea
·
-
34 votesRob Koelmans
supported this idea
·
I think not a single MS-Access programmer is waiting to move access or sql data to CDS to get their access applications not working anymore. You can only afford to extend with PowerApps/Flow, not replace years of Access development. A MySQL like Flow connector would also make a huge benefit (a connector that builds up a gateway to Flow/Automation from premises to Flow). We extended the reverse proxy as described in my suggestion above with VBA code that uses the Jscript COM Add-In to handle incoming and outgoing JSON. Incoming JSON fills a manually created ADO object which is being assigned as record source in form OnOpen events. Works like a charm. We plan to make that Odata V4 compatible, not just for data but als actions/methods that call vba functions/procedures.