Feedback by UserVoice

isladogs

My feedback

  1. 10 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
      isladogs commented  · 

      Hi Anders
      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 used

      isladogs shared this idea  · 
    • 302 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        10 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
        isladogs supported this idea  · 
        isladogs commented  · 

        Also allow users to move direct to SQL view from the ribbon rather than first selecting design view

      • 241 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          10 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
          isladogs supported this idea  · 
        • 68 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            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

          • 67 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              6 comments  ·  Access (Desktop Application) » Local Data  ·  Flag idea as inappropriate…  ·  Admin →
              isladogs commented  · 

              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

            Feedback and Knowledge Base