Rob Koelmans
My feedback
-
193 votes10 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
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.
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
·
-
1 vote0 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →Rob Koelmans
shared this idea
·
-
77 votesRob Koelmans
supported this idea
·
-
50 votesRob Koelmans
supported this idea
·
-
37 votesRob Koelmans
supported this idea
·
If you have a Power Automation Connector that Desktop Access, Word and Excel can connect to at its behind side you could easily provide a VBA function caller to anything in PowerAutomate. Access FE versions (that are cleaned out of code and data that should run behind a wall) can use the http action initiator to use their BE-versions to generate JSON on behalf of the WebAPI that Power Automation effectively provides. This way developers can have the BE deployed in an Azure Virtual Machine and thus have a structure to get their application 3-tier and GDPR-compliant. The VBA-code would would of course also become available automatically to PowerApps en other front-end environments. This is simular to how a Power Automate MySQL-connector from Microsoft or some third party works. Call it the 'Desktop Office Automation Connector' :-)