Access bug fixes — Versions 2511 through 2601
Version 2511 (Build 19426) Bug Name Issue Fixed Query Design view showed incorrect joins after selecting SQL text When using the Monaco SQL editor with a query containing multiple joins, selecting text in SQL view with Ctrl+A and then switching back to Design View could trigger a spurious alert and cause one of the joins to appear removed in the design grid. The underlying SQL wasn't actually affected, but the Design view displayed incorrect join information. This is corrected so that switching between SQL view and Design view preserves all joins accurately. Version 2512 (Build 19530) Bug Name Issue Fixed Datasheet forms with nested subforms showing errors after system changes When using datasheet forms containing nested subforms on systems where a system change occurs — such as disconnecting and reconnecting a Remote Desktop session — Access could display a GDI error. This happened because collapsed sublists held references to system brushes that were destroyed during the system change. This is fixed so that all sublists properly handle system resource changes. F4 key did not open the Properties pane in the Query SQL editor When the Monaco SQL editor was enabled, pressing F4 in the Query editor's SQL view didn't properly open the Properties pane. Instead, the pane would either flash briefly or appear incorrectly positioned in the top-left corner of the screen. The F4 shortcut now correctly opens the Properties pane in SQL view. Pressing F5 in the Query SQL editor cleared all SQL text When using the Monaco SQL editor in the Query designer, pressing F5 (Run) could clear all the SQL text from the editor. This is fixed so that running a query with F5 no longer affects the SQL text in the editor. Text not visible when renaming items in the Navigation Pane in dark themes When using the Black (or other dark) Office theme, renaming an object in the Navigation pane resulted in text that was nearly invisible due to insufficient contrast. The rename text box now uses appropriate colors that provide sufficient contrast in all themes. Advanced Filter/Sort opened a standalone query window instead of a filter window When opening a table in Datasheet view and selecting Sort & Filter > Advanced > Advanced Filter/Sort from the ribbon, Access incorrectly opened a full standalone query design window instead of the expected limited filter query window. The filter query window includes a Toggle Filter button to apply the query as a filter. This is corrected, so the command opens the proper filter window. Refreshing an Access ODBC connection in Excel returned an error When refreshing an ODBC connection to an Access database from Excel, users could receive the error "Operation is not supported for this type of object." This is resolved so that Access ODBC connections refresh successfully. Please continue to let us know if this is helpful and share any feedback you have.
Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server
Today, I worked on a service request that our customer asked about how SQL Server sorts the uniqueidentifier data type. We know that uniqueidentifier store globally unique identifiers (GUIDs). GUIDs are widely used for unique keys due to their extremely low probability of duplication. One common method to generate a GUID in SQL Server is by using the NEWID() function. However, the ordering of GUIDs, especially those generated by NEWID(), can appear non-intuitive. I would like to share my lessons learned how to determine the shorting method using uniqueidentifier and NEWID().
Onedrive albums - allow custom photo sorting
One of the things I like about google photo albums is that you can easily drag photos around in order to create a "custom sort" of the photos. This is important in order to make a gallery look "just right". I like many things about onedrive albums (and onedrive), and I'd like to start using it, but as far as I can tell, it doesn't allow for any custom photo sorting. If I am right about this, will microsoft ever be adding a "custom photo sort" capability to the onedrive albums? ThanksHow to Detect Files of the Same Size on your Computer via PowerShell
Learn how to use PowerShell to detect files of the same size on your computer quickly and easily. This article provides a script to automate the process and save storage space. Follow the step-by-step instructions and improve your file management skills with PowerShell automation.
Sort by Name not proper for numbered files.
Just trying to understand the logic of OneDrive's "Sort by Name" when it comes to numbers. Take a look at the below. "9-26" shouldn't be coming before "9-3". The number 26 should be perceived as after 3. I cannot honestly say I've seen that issue with other storage services.Sheet View is generally available
Introducing Sheet View on Excel for the web, a new way of letting you create customized views in an Excel worksheet to sort and filter your data. You can filter to display only the records that are important to you without being affected by others collaborating in the document. All your cell level edits propagate through the file regardless of your view, so you can make all of your in-cell edits in your Sheet View, too.Apply view only for a specific folder
Hello everyone I have a folder within a default document library which is connected to a team in teams. So, in this folder I have documents that must be sorted by its number in the file name. Example: File_1 File_2 ... First, I figured out that it isn't possible to sort numeric, if the number is only in the filename. SharePoint will then sort it like: File_1 File_11 File_2 ... Very frustrating but okay. So, I created a numeric column that can be used to sort the files properly. But what I noticed is that the column is now visible in the whole document library 😞 So now my question: Is it possible to apply the column to only being visible in this specific folder where I need it? I tried it with different views and so on, but it seems that this cannot be achieved. Thanks for your help.
Sharepoint Sort by Czech Alphabet (or set locale)
Dear community, I'm sorry if the question was already asked but I couldn't find any. I would like to ask, if it's possible to sort by (order by) alphabet (which works fine) but to specify Czech alphabet, which has specific letters in addition to English. We have built employee directory based on LocalePeopleResults (package https://github.com/microsoft-search/pnp-modern-search) in Sharepoint but we are unable to sort by Czech alphabet. Therefore for example letter "Č" which is after letter "C" is at the end of directory as special character. Our sharepoint site language is set to Czech, basically everything is in Czech, but not the alphabet. Would you have any recommendation what we could try or if we can set locale in KQL? Custom managed property probably can not be used as number of employees is not final. Thank you in advance. All the Best, Adam
