16 votesisladogs commented
Yes of course there are many legitimate uses for importing/exporting data using VBA.
However, when an FE is distributed as an ACCDE, I think it less likely that end users will be doing that. What I'm requesting is an option to prevent tables/queries being copied/ exported /imported to/from ACCDE files when these are created
I am in no way disagreeing that for higher level security SQL Server should be usedisladogs shared this idea ·
277 votesisladogs supported this idea ·
86 votes5 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →isladogs commented
I've previously voted for similar suggestions:
a) add a JSON.dll
b) add an Access equivalent of Excel Power Query (Get & Transform)
However, its done, the important thing is that it is done.
In the meantime, I will continue / developing using my JATFA (JSON Analyse & Transform for Access) app which is available from http://www.mendipdatasystems.co.uk/json-analyse-transform/4594138310
Of course, if MS adds this functionality, my app may well become redundant