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 ·
Also allow users to move direct to SQL view from the ribbon rather than first selecting design view
68 votes5 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
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
I agree with the above. Whilst SQL Server is appropriate for many purposes, not all my clients feel confident enough to deploy it. For them, Access is still the favoured option. Larger capacity would be useful