Feedback by UserVoice

Mark Burns

My feedback

  1. 12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
  2. 67 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Burns supported this idea  · 
  3. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    this was suggested in a previous topic - I suggested the best compromise was to modify the now() function to take an optional parameter for timezone (to unclude UTCZulu as an option)

  4. 11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Burns supported this idea  · 
  5. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    Disagree!
    Whiel having a finer means of controlling the next autonumber might be nice, what you are describing is long established and well documented behavior. IT SHOULD NOT BE CHANGED as doing so could break many existing applications which rely on the currently defined behavior.

  6. 233 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    24 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →

    The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!

    Thanks,
    Ebo [MSFT[

    An error occurred while saving the comment
    Mark Burns commented  · 

    "No Current Plan"??! This is VERY Disappointing news, indeed!

  7. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for calling out this issue Subhabrata.
    We are investigating this issue.

    @Mark Burns – this is a different issue that we are looking into as well. Please post as a separate suggestion so people can vote on it and we can address.

    Michal [MSFT]

    An error occurred while saving the comment
    Mark Burns commented  · 
    An error occurred while saving the comment
    Mark Burns commented  · 

    @Frank / Microsoft,

    Isn't it a tad silly to have to UN-vote for something I DO support to add something new - only to then un-vote for what I just added to put my vote back where I had it? (and then leave the new suggestion/idea with NO votes?! ...or just forget that I supported another idea instead? The 20-vote limit is just silly to begin with, though I understand that it serves and anti-spam purpose.)

    An error occurred while saving the comment
    Mark Burns commented  · 

    @Frank,

    Oh, yes, I know that. They're there, but they're unusable by 3rd-party / out-of-process applications!
    So, they're basically NOT there at the same time.

    An error occurred while saving the comment
    Mark Burns commented  · 

    I am unable to post any new items due to the 20-vote (dumb) limit for voting on items. Once this limit is reached posting new requests is disabled.

    An error occurred while saving the comment
    Mark Burns commented  · 

    This is only made worse by the affects of the different MS-Office installers. Traditional .MSI office installs do have this issue as stated. Click-To-Run (App-V based) installed Office apps have a WORSE issue in that the ODBC drivers APPEAR TO NOT BE INSTALLED AT ALL to the host OS.

  8. 25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    Smilin Jack...

    You are complaining about something that is proverbially as old as the hills, and is a "symptom" of the normal operations of the Jet/ACE Database engines. In short, when a locking file is created upon opening a database file (and/or subsequently deleted) things ARE written to the database file, and the date updated is modified accordingly AND CORRECTLY for the OS/filesystem's rules of operations.
    In short, if you really want this sort of capability, then move/copy all the database files to a folder with READ ONLY permissions (no Create/Edit/Delete permissions in the folder), and you can then open them with impunity and suffer no ill effects on the file's last updated datestamp. You WILL suffer the slings and arrows of Access complaining about the Read Only folder permissions, however.
    This is a case of picking your poisons, I'm afraid.

  9. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Burns supported this idea  · 
    Mark Burns shared this idea  · 
  10. 10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    Mark Burns commented  · 

    @Frank - you misunderstand the issue.
    If you boy an o365 version that DOEs have Access...
    but you select the Click-to-Run deployment installer, then oafer O365 (and Access) ARE installed, the ACE Engine ODBC Drivers are NOT VISIBLE to the Host OS.
    This is the reason for needing the ACE 2016 redistributable package released (as a .MSI install) .... so that scripting tasks or other 3rd-party apps can SEE and USE the ACE Drivers for CTR-installed Office clients!

    Mark Burns shared this idea  · 
  11. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    The ONLY way this could be done, given the current behind-the-scenes way that multiselect fields are implemented is if the Access USER had ADMIN RIGHTS and SCHEMA CHANGE rights to the *PRODUCTION* SQL Server database (at least at the point in time when a multiselect field were to be added to the database).

    NO SQL Server DBA in their right minds would EVER allow such to be the case for a PRODUCTION database as it would generally be considered suicidal!

  12. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    18 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    @All,

    Please don't misunderstand me here. I'm all for enhancing MS Access security and convenience at the same time. I'd dearly LOVE to see some API improvements for security, such as an .OpenDatabasePassword property for the Access.Application (and/or .DBEngine) objects. (set the password property value before the .opendatabase call, and the password is cleared by the opendatabase call, but only at the end, so it persists during the call - and can be passed down to child databases such as those in linked tables.)

    If there were a convenient way to leverage that via the access application command line also, GREAT!

    ...it's just that such methods are ripe with the potential for serious abuse/misuse - Dolly's excellent keys-under-the-doormat example being a wonderful one which underscores my concern about there potentially being unencrypted passwords in desktop shortcut command line strings - because we ALL just KNOW it WOULD HAPPEN like that in real life (we lazy/ignorant humans being who we are).

    I'm only trying to make the point that such suggestions like this need deeper analysis, and the real answers here fall more into the "extend a security API to developers" category than they do as simpler request like "add a command-line password parameter"-type request.

    An error occurred while saving the comment
    Mark Burns commented  · 

    This is a great idea...if compromised security is your goal. Allowing such passwords on the command line of a shortcut will achieve only 2 things. 1) your desired outcome; 2) the easiest path to compromised database passwords in recorded history (right-click on the shortcut and hit Properties and voila! the password is revealed to ALL!)

  13. 11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    Mark Burns commented  · 

    Ben,

    Your posted Link is now broken.
    Any chance that you have a better one?

  14. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    I would vote for this if I had any free votes left! (*20* votes is a ridiculous limit)

  15. 31 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application) » Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    Traci,

    The edit-ability of a set of crosstab results would be highly problematic in an of itself.
    The UI is one issue, but the edit-ability of the underlying query results is actually a far more difficult challenge to achieve. This is particularly noticeable in that the key ID fields and similar associations are often lost/tossed aside in the shuffle of compiling the crosstab results, particularly when summaries or other domain functions are employed in generating the crosstab results.

  16. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Mark Burns shared this idea  · 
  17. 363 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    16 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →

    The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!

    Thanks,
    -Access Product Team

    An error occurred while saving the comment
    Mark Burns commented  · 

    this request duplicate the basic point of at least 2-3 other requests already posted.

  18. 17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    Mark Burns commented  · 

    I would definitely vote for this if I had any votes left!!

  19. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    That actually sounds like it could be a display driver issue, and not so much an Access issue. Have you checked out available updates for your display adapter lately?

  20. 65 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Planned  ·  5 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Burns commented  · 

    ADDITIONALLY - Make the Access UI respond to the Browser magnification hotkeys Ctrl-+ and Ctrl-(minus/hyphen). Those of us users with poorer visual acuity issues really appreciate the on-demand freedom to scale up UI items in modern browsers this way - WHY CAN'T ACCESS (and other Office Apps) DO THIS TOO!?? ...or do you folks imagine that somehow everyone has perfect vision and/or our eyes don't get tired/strained as the day stretches on?

    Mark Burns supported this idea  · 

Feedback and Knowledge Base