Tag Archives: microsoft
Failed to change notification settings in Windows 11
When I right click on the bell at the end of the taskbar, and choose “Notification settings”, the Settings app window opens for a fraction of a second and then disappears.
When I right click on the bell at the end of the taskbar, and choose “Notification settings”, the Settings app window opens for a fraction of a second and then disappears. Read More
How I got 85% in Microsoft AZ-305
I achieved an 85% score in the Microsoft AZ-305 exam and I still couldn’t believe it thanks to Passexam4sure’s comprehensive study materials. Their AZ-305 Dumps PDF, practice tests, and exam questions provided thorough coverage of key concepts and real-world scenarios, enabling me to solidify my understanding and test my knowledge effectively. Regular practice and revisiting challenging topics with Passexam4sure’s resources were instrumental in my success. I highly recommend Passexam4sure for anyone aiming to excel in the AZ-305 certification exam.
I achieved an 85% score in the Microsoft AZ-305 exam and I still couldn’t believe it thanks to Passexam4sure’s comprehensive study materials. Their AZ-305 Dumps PDF, practice tests, and exam questions provided thorough coverage of key concepts and real-world scenarios, enabling me to solidify my understanding and test my knowledge effectively. Regular practice and revisiting challenging topics with Passexam4sure’s resources were instrumental in my success. I highly recommend Passexam4sure for anyone aiming to excel in the AZ-305 certification exam. Read More
Export Data from a TSV File onto Excel
Hi When I select export data, the data is downloaded onto word and I require the data to be exported on excel. The system would always export onto excel why has this function or command changed to word?
I need assistance
Hi When I select export data, the data is downloaded onto word and I require the data to be exported on excel. The system would always export onto excel why has this function or command changed to word?I need assistance Read More
How to use mmult when array contains blanks?
What I need is simple and described in the subject:
I would like to multiply matrices that containg blanks (treating blanks as 0). I read that using the formula N() would solve the problem, but it doesn’t – probably N() does not work on matrices.
Any help would be appreciated!
What I need is simple and described in the subject: I would like to multiply matrices that containg blanks (treating blanks as 0). I read that using the formula N() would solve the problem, but it doesn’t – probably N() does not work on matrices. Any help would be appreciated! Read More
Startup Showcase: 3-2-1-GoCheck
Using AI for Digital Background Checking
3-2-1 Go Check, a global background checking startup, and has revolutionized its services by leveraging the Microsoft Founders Hub program. The company offers its comprehensive background checking solutions as a Software as a Service (SaaS), and Founders’ Hub benefits have enhanced its accessibility and efficiency.
Founders Hub Benefits
Use of Microsoft 365: 3-2-1 Go Check has a global team located in Hungary, UK, Czech Republic, Australia, Canada, India, and Germany and they are under one calendar and mailbox.
Join Microsoft for Startups Founders’ Hub today!
Microsoft Tech Community – Latest Blogs –Read More
Windows 11 Virtual Desktop – method to customize taskbar per desktop (instead of same for all)
First off… I LOVE the virtual desktop feature. Thank you Thank you Thank you… that has been a favorite feature of Linux GDE’s for years for me (is it safe to mention I’m a Linux user in here??? )
So now the question — and its truly ICING for the cake which no one NEEDS but it sure is GOOD:
Can I hack registry, set GPO, create a special ini file somewhere, powershell-fu or beg a feature update my way into having a different taskbar configuration per virtual desktop?
I am not a stranger to any of those, but do not recall seeing anything like that recently. I do truly understand the scope of that request so no hard feelings here. Google was not my friend on this subject other than to reveal I am far from the only asker. And of course you know the registry tree is like the library of congress – if you aren’t a frequent flyer then the many seemingly duplicate areas in alternate locations and the oh so fun GUID-only labeled options (and the hidden options you have to know the key name exists to add in and modify by hand) need a little bit of indexing for us folk that didn’t design that monster of a database. No knocks there, but I have worked with various devs for 12 years now and I know there is top secret stuff in there that you Windows devs will never reveal to us common WindowsOS non-dev folk (and tbh it’s usually for very good reasons )
First off… I LOVE the virtual desktop feature. Thank you Thank you Thank you… that has been a favorite feature of Linux GDE’s for years for me (is it safe to mention I’m a Linux user in here??? ) So now the question — and its truly ICING for the cake which no one NEEDS but it sure is GOOD:Can I hack registry, set GPO, create a special ini file somewhere, powershell-fu or beg a feature update my way into having a different taskbar configuration per virtual desktop? I am not a stranger to any of those, but do not recall seeing anything like that recently. I do truly understand the scope of that request so no hard feelings here. Google was not my friend on this subject other than to reveal I am far from the only asker. And of course you know the registry tree is like the library of congress – if you aren’t a frequent flyer then the many seemingly duplicate areas in alternate locations and the oh so fun GUID-only labeled options (and the hidden options you have to know the key name exists to add in and modify by hand) need a little bit of indexing for us folk that didn’t design that monster of a database. No knocks there, but I have worked with various devs for 12 years now and I know there is top secret stuff in there that you Windows devs will never reveal to us common WindowsOS non-dev folk (and tbh it’s usually for very good reasons ) Read More
Combine both : Get-MgBetaUser and Get-MgBetaReportAuthenticationMethodUserRegistrationDetail
Hi Guys I want to pull all user login details in Entra together ith MFA details for each user using the two modules to end up with an array for extracting a report like below. Kindly assist in joining data from the two modules, thank you.
$mfaData = Get-MgBetaReportAuthenticationMethodUserRegistrationDetail -Identity $user | Select-Object UserDisplayName,UserPrincipalName, UserType,IsAdmin,DefaultMfaMethod,IsMfaRegistered,IsMfaCapable,IsPasswordlessCapable, MethodsRegistered
$userData = @()
foreach ($user in $entraIdUsers) {
$entraIdUsers = Get-MgBetaUser -All -Property Id, DisplayDisplayNameName, UserPrincipalName, SignInActivity, CreatedDateTime, AccountEnabled
$userData += [PSCustomObject]@{
“Id” = $user.Id
“DisplayName” = $user.DisplayName
“UPN” = $user.UserPrincipalName
“CreatedDate” = $user.CreatedDateTime
“AccountEnabled” = $user.AccountEnabled
“LastSuccessfulSigninDate” = $user.SignInActivity.lastSuccessfulSignInDateTime
“LastInteractiveSignIn” = $user.SignInActivity.LastSignInDateTime
“LastNon_InteractiveSignIn” = $user.LastNonInteractiveSignInDateTime
“UserType” = $mfaData.UserType
“IsAdmin” = $mfaData.IsAdmin
“IsMfaRegistered” = $mfaData.IsMfaRegistered
“IsMfaCapable” = $mfaData.IsMfaCapable
“IsPasswordlessCapable” = $mfaData.IsPasswordlessCapable
“DefaultMfaMethod” = $mfaData.DefaultMfaMethod
“UserPreferredMethodForSecondaryAuthentication” = $mfaData.UserPreferredMethodForSecondaryAuthentication
“Methods registered” = $mfaData.MethodsRegistered -join “, “
}
}
Hi Guys I want to pull all user login details in Entra together ith MFA details for each user using the two modules to end up with an array for extracting a report like below. Kindly assist in joining data from the two modules, thank you. $mfaData = Get-MgBetaReportAuthenticationMethodUserRegistrationDetail -Identity $user | Select-Object UserDisplayName,UserPrincipalName, UserType,IsAdmin,DefaultMfaMethod,IsMfaRegistered,IsMfaCapable,IsPasswordlessCapable, MethodsRegistered
$userData = @()
foreach ($user in $entraIdUsers) {
$entraIdUsers = Get-MgBetaUser -All -Property Id, DisplayDisplayNameName, UserPrincipalName, SignInActivity, CreatedDateTime, AccountEnabled
$userData += [PSCustomObject]@{
“Id” = $user.Id
“DisplayName” = $user.DisplayName
“UPN” = $user.UserPrincipalName
“CreatedDate” = $user.CreatedDateTime
“AccountEnabled” = $user.AccountEnabled
“LastSuccessfulSigninDate” = $user.SignInActivity.lastSuccessfulSignInDateTime
“LastInteractiveSignIn” = $user.SignInActivity.LastSignInDateTime
“LastNon_InteractiveSignIn” = $user.LastNonInteractiveSignInDateTime
“UserType” = $mfaData.UserType
“IsAdmin” = $mfaData.IsAdmin
“IsMfaRegistered” = $mfaData.IsMfaRegistered
“IsMfaCapable” = $mfaData.IsMfaCapable
“IsPasswordlessCapable” = $mfaData.IsPasswordlessCapable
“DefaultMfaMethod” = $mfaData.DefaultMfaMethod
“UserPreferredMethodForSecondaryAuthentication” = $mfaData.UserPreferredMethodForSecondaryAuthentication
“Methods registered” = $mfaData.MethodsRegistered -join “, “
}
} Read More
the empty area in the bottom margin of excel is too big
My job requires me to create written reports using excel. however, since the last update, my excel has an empty area at the bottom that is too big.
how can I make my excel full without sacrificing the footer?
thank u.
My job requires me to create written reports using excel. however, since the last update, my excel has an empty area at the bottom that is too big. how can I make my excel full without sacrificing the footer? thank u. Read More
OneDrive Sharing Links – Does the “Guest Access Expiry policy” Apply to “Specific People” Links?
I’m having an issue with a OneDrive integration in an application I’m developing. The integration allows creating “Specific People” sharing links, which are emailed to external users and require them to authenticate their email before accessing the shared file/folder.
I have seen in many places that “Specific People” sharing links do not expire. There is no expiry field available when creating the link, and I can’t find any expiry settings in the Sharepoint Admin Center that seem to apply to “Specific People” links. However, some of my clients using my OneDrive integration have noticed that many of their “Specific People” links get dropped unexpectedly after a period of one or two months. I have also been able to reproduce this issue in my developer account.
There is one setting in the Sharepoint Admin Center that seems like it might apply:
Guest Access to a site or OneDrive will expire automatically after this many days
Since I’ve seen many references to the fact that “Specific People” links never expire, I thought this setting was not relevant. I also interpreted “Guest Access” as referring to “Guest Users”, which can be added in the M365 Admin Center. My integration does not make any use of Guest Users, so I felt fairly confident that this setting did not apply to my use case.
However, I can’t seem to find definite confirmation that this “Guest Access Expiry” setting does not apply to “Specific People” links. Since my clients links keep getting dropped, and I’ve now been able to reproduce this on my own account, I have to assume this is either a bug in OneDrive, or that this setting – or another setting I’ve not yet found – is causing the links to disappear.
I’ve noticed on my own account that some emails get dropped off of the “Specific People” link after a certain period of time, while others do not. Even though I added all the emails to the link at the same time. This inconsistency makes it seem more like a big than something that is being controlled by an admin setting.
Can someone please confirm whether the setting I referenced affects “Specific People” links, and/or if there is another OneDrive/Sharepoint/M365 setting that can cause “Specific People” links to be dropped after a certain period of time? Has anyone else noticed “Specific People” links getting dropped over time, or just one or two of the emails on a multi-person link getting dropped?
I’m having an issue with a OneDrive integration in an application I’m developing. The integration allows creating “Specific People” sharing links, which are emailed to external users and require them to authenticate their email before accessing the shared file/folder. I have seen in many places that “Specific People” sharing links do not expire. There is no expiry field available when creating the link, and I can’t find any expiry settings in the Sharepoint Admin Center that seem to apply to “Specific People” links. However, some of my clients using my OneDrive integration have noticed that many of their “Specific People” links get dropped unexpectedly after a period of one or two months. I have also been able to reproduce this issue in my developer account. There is one setting in the Sharepoint Admin Center that seems like it might apply:Guest Access to a site or OneDrive will expire automatically after this many daysSince I’ve seen many references to the fact that “Specific People” links never expire, I thought this setting was not relevant. I also interpreted “Guest Access” as referring to “Guest Users”, which can be added in the M365 Admin Center. My integration does not make any use of Guest Users, so I felt fairly confident that this setting did not apply to my use case. However, I can’t seem to find definite confirmation that this “Guest Access Expiry” setting does not apply to “Specific People” links. Since my clients links keep getting dropped, and I’ve now been able to reproduce this on my own account, I have to assume this is either a bug in OneDrive, or that this setting – or another setting I’ve not yet found – is causing the links to disappear. I’ve noticed on my own account that some emails get dropped off of the “Specific People” link after a certain period of time, while others do not. Even though I added all the emails to the link at the same time. This inconsistency makes it seem more like a big than something that is being controlled by an admin setting. Can someone please confirm whether the setting I referenced affects “Specific People” links, and/or if there is another OneDrive/Sharepoint/M365 setting that can cause “Specific People” links to be dropped after a certain period of time? Has anyone else noticed “Specific People” links getting dropped over time, or just one or two of the emails on a multi-person link getting dropped? Read More
Why don’t Page Up/Down work for the rendered text of an email? They work for browsers etc.
The Page Up and Page Down keys work everywhere except for the body of a displayed email message. I have to scroll the window with the scroll bar. How can I fix this? Thank you.
The Page Up and Page Down keys work everywhere except for the body of a displayed email message. I have to scroll the window with the scroll bar. How can I fix this? Thank you. Read More
Is there a way to take data from one sheet and transpose it into another sheet.
Good morning,
I am trying to take the data that I can copy and paste into excel in this format from a HR system.
And place the name and the start and end times into a sheet that appears like the below.
I want the name to auto populate and likewise if a start time from the top table is 0700 and end time is 1900 I want the formulas to identify that and fill it in with the letter A. Then remain blank if they are not working at that time.
Good morning, I am trying to take the data that I can copy and paste into excel in this format from a HR system. And place the name and the start and end times into a sheet that appears like the below. I want the name to auto populate and likewise if a start time from the top table is 0700 and end time is 1900 I want the formulas to identify that and fill it in with the letter A. Then remain blank if they are not working at that time. Read More
Dropdown Menu for fonts
Dear Microsoft: Thank you, for ensuring that my font selection is a infuriating experience.
It evokes the spirit of all the subtle ways Microsoft office kneecaps user productivity.
Maybe instead of 34604432 useless fonts and 20 usable ones, give me font selection in a way that makes sense.
Limit dropdown menus to 10. A fricking scroll bar the width of gold leaf doesn’t help.
Instead of alphabetical organization, SANS SERIF. Then SERIF. Then retard BS, like unicode, dingaling and all the dogshit moronic stuff you add to clutter up my **bleep**ing workspace.
Organize the technology to follow along the user’s thinking process.
Dear Microsoft: Thank you, for ensuring that my font selection is a infuriating experience.It evokes the spirit of all the subtle ways Microsoft office kneecaps user productivity. Maybe instead of 34604432 useless fonts and 20 usable ones, give me font selection in a way that makes sense. Limit dropdown menus to 10. A fricking scroll bar the width of gold leaf doesn’t help. Instead of alphabetical organization, SANS SERIF. Then SERIF. Then retard BS, like unicode, dingaling and all the dogshit moronic stuff you add to clutter up my **bleep**ing workspace. Organize the technology to follow along the user’s thinking process. Read More
Office 365: Microsoft Kneecaps User Productivity
Microsoft Kneecaps User Productivity (MKUP)
1. Custom Color Theme in Office requires me to copypaste HEX Code after a 3 layer submenu from the home tab. Change ONE color, then exit, copypaste the 2nd HEX code, and repeat. And repeat…
2. Powerpoint selection pane. Rename the shape, text, image etc. Typing prompt starts at the beginning without highlighting the text. Type right away and you get COVER SHADERRectangle 19.
My fists ball up and I smash the keyboard of my ASUS into smithereens.
3. Insert Stock Image search bar, click for the type prompt. As I remove my finger from the trackpad, my mouse icon slips from the window. I type and nothing happens. I start trembling and say “I’m going to strangle Bill Gates,” through clenched teeth. No wonder he’s so skittish around paparazzi. He knows what he did.
4. Text boxes, Powerpoint. I don’t know man. I don’t know. I hate them. I just put a shape behind it and move on. What’s the deal? The border won’t snug up, the various wrap text, autofit, etc options make no sense.
5. Stop hiding my files in one drive. I don’t know where they go. I don’t know the difference between
This PC OS Users Nolan Documents
and Start Backup Documents
you hide my stuff in One Drive, or make me select This Computer every time I save, repeating the same nonsense frig around with dropdown menus roughly 5893462049305 times.
The next day, I’m looking for my document because you slipped one past me. Hide his stuff in One Drive. Hahaha. I don’t see One Drive. I don’t know where my file is. I explode, spin around, and frisbee my laptop into the wall, denting the plaster and traumatizing the dog.
I get blamed for your corporate rage. You bottled it up and inadvertently built it into the user experience.
Microsoft Kneecaps User Productivity (MKUP) 1. Custom Color Theme in Office requires me to copypaste HEX Code after a 3 layer submenu from the home tab. Change ONE color, then exit, copypaste the 2nd HEX code, and repeat. And repeat… 2. Powerpoint selection pane. Rename the shape, text, image etc. Typing prompt starts at the beginning without highlighting the text. Type right away and you get COVER SHADERRectangle 19.My fists ball up and I smash the keyboard of my ASUS into smithereens. 3. Insert Stock Image search bar, click for the type prompt. As I remove my finger from the trackpad, my mouse icon slips from the window. I type and nothing happens. I start trembling and say “I’m going to strangle Bill Gates,” through clenched teeth. No wonder he’s so skittish around paparazzi. He knows what he did. 4. Text boxes, Powerpoint. I don’t know man. I don’t know. I hate them. I just put a shape behind it and move on. What’s the deal? The border won’t snug up, the various wrap text, autofit, etc options make no sense. 5. Stop hiding my files in one drive. I don’t know where they go. I don’t know the difference between This PC OS Users Nolan Documentsand Start Backup Documentsyou hide my stuff in One Drive, or make me select This Computer every time I save, repeating the same nonsense frig around with dropdown menus roughly 5893462049305 times.The next day, I’m looking for my document because you slipped one past me. Hide his stuff in One Drive. Hahaha. I don’t see One Drive. I don’t know where my file is. I explode, spin around, and frisbee my laptop into the wall, denting the plaster and traumatizing the dog. I get blamed for your corporate rage. You bottled it up and inadvertently built it into the user experience. Read More
How to remove/hide white space in SharePoint?
Hi, I’m new to SharePoint.
I wonder if the blank white space on our landing page/section can be removed? I’m stuck here :’) I’ve done some research, and there’s no out-of-the-box solution that can be used to hide this. However, I believe we can use CSS or something similar to solve this issue. Has anyone tried using a CSS injector to solve this? Would you mind sharing how to do this?
I’ve attached sample image below so that you can visualize it. Appreciate it if there is any help! Thanks
Hi, I’m new to SharePoint. I wonder if the blank white space on our landing page/section can be removed? I’m stuck here :’) I’ve done some research, and there’s no out-of-the-box solution that can be used to hide this. However, I believe we can use CSS or something similar to solve this issue. Has anyone tried using a CSS injector to solve this? Would you mind sharing how to do this? I’ve attached sample image below so that you can visualize it. Appreciate it if there is any help! Thanks Read More
What to Do When QuickBooks Automatic Backup not working
Troubleshooting QuickBooks Automatic Backup Not Working: Causes, Symptoms, and Solutions
QuickBooks Automatic Backup is a critical feature that helps safeguard your financial data by automatically creating backup copies of your company file. However, encountering issues where QuickBooks Automatic Backup is not working can be concerning for users. In this article, we’ll explore the possible reasons behind this problem, its symptoms, and effective solutions to ensure your data remains protected.
What is QuickBooks Automatic Backup?
QuickBooks Automatic Backup is a feature that allows users to schedule regular backups of their company file without manual intervention. These backups provide a safety net in case of data loss due to system failures, corruption, or other unforeseen circumstances.
Reasons for QuickBooks Automatic Backup Not Working:
Backup Settings Misconfiguration: Incorrect configuration of backup settings within QuickBooks can prevent the automatic backup feature from working as intended. This includes improper scheduling, incorrect backup locations, or disabled backup options.
Interruptions in Network Connectivity: QuickBooks relies on stable network connectivity to perform automatic backups. If there are interruptions or issues with the network connection, the backup process may fail or become unreliable.
Insufficient Disk Space: If the destination drive where QuickBooks is set to save automatic backups runs out of disk space, the backup process will fail. Insufficient disk space can prevent QuickBooks from creating new backup files or overwrite existing ones.
Corrupted QuickBooks Installation: Issues with the QuickBooks installation itself, such as corrupted program files or missing components, can interfere with the automatic backup process. A damaged installation can lead to various errors and malfunctions, including backup failures.
Conflicts with Third-Party Software: Certain third-party applications or security software installed on the computer may conflict with QuickBooks, causing issues with the automatic backup process. This can include antivirus programs, firewalls, or backup utilities that interfere with QuickBooks operations.
Symptoms of QuickBooks Automatic Backup Not Working:
No backup files are created at the scheduled times.Error messages or notifications indicating backup failures.Manual attempts to initiate backup result in errors or unexpected behavior.
Solutions to QuickBooks Automatic Backup Not Working:
Verify Backup Settings: Review the backup settings within QuickBooks to ensure they are configured correctly. Check the backup schedule, destination folder, and any other relevant settings to confirm they match your requirements.
Check Network Connectivity: Ensure that the computer running QuickBooks has a stable and reliable network connection. Troubleshoot any network issues that may be causing interruptions or delays in the backup process.
Free Up Disk Space: Check the available disk space on the drive where QuickBooks saves backup files. Delete any unnecessary files or move existing backups to a different location to free up space. Consider increasing the storage capacity if disk space is consistently low.
Repair QuickBooks Installation: If QuickBooks is experiencing issues due to a corrupted installation, repair the installation using the QuickBooks Install Diagnostic Tool or by reinstalling QuickBooks. This can help resolve any underlying software issues affecting the automatic backup feature.
Disable Conflicting Software: Temporarily disable or adjust settings for any third-party software that may be interfering with QuickBooks operations. This includes antivirus programs, firewalls, or backup utilities that may be blocking or interrupting the backup process.
Manually Initiate Backup: If automatic backups are not working reliably, manually initiate backups from within QuickBooks as a temporary workaround. This ensures that you have recent backup copies of your company file until the automatic backup feature is restored.
Conclusion:
QuickBooks Automatic Backup is a valuable feature that helps protect your financial data from loss or corruption. However, when this feature is not working correctly, it can jeopardize the integrity of your backups and leave your data vulnerable. By identifying the possible reasons for automatic backup failures and implementing the solutions outlined in this article, you can ensure that your data remains safe and secure in QuickBooks. Regularly monitor backup processes and address any issues promptly to maintain data integrity and peace of mind.
Troubleshooting QuickBooks Automatic Backup Not Working: Causes, Symptoms, and SolutionsQuickBooks Automatic Backup is a critical feature that helps safeguard your financial data by automatically creating backup copies of your company file. However, encountering issues where QuickBooks Automatic Backup is not working can be concerning for users. In this article, we’ll explore the possible reasons behind this problem, its symptoms, and effective solutions to ensure your data remains protected.What is QuickBooks Automatic Backup?QuickBooks Automatic Backup is a feature that allows users to schedule regular backups of their company file without manual intervention. These backups provide a safety net in case of data loss due to system failures, corruption, or other unforeseen circumstances.Reasons for QuickBooks Automatic Backup Not Working:Backup Settings Misconfiguration: Incorrect configuration of backup settings within QuickBooks can prevent the automatic backup feature from working as intended. This includes improper scheduling, incorrect backup locations, or disabled backup options.Interruptions in Network Connectivity: QuickBooks relies on stable network connectivity to perform automatic backups. If there are interruptions or issues with the network connection, the backup process may fail or become unreliable.Insufficient Disk Space: If the destination drive where QuickBooks is set to save automatic backups runs out of disk space, the backup process will fail. Insufficient disk space can prevent QuickBooks from creating new backup files or overwrite existing ones.Corrupted QuickBooks Installation: Issues with the QuickBooks installation itself, such as corrupted program files or missing components, can interfere with the automatic backup process. A damaged installation can lead to various errors and malfunctions, including backup failures.Conflicts with Third-Party Software: Certain third-party applications or security software installed on the computer may conflict with QuickBooks, causing issues with the automatic backup process. This can include antivirus programs, firewalls, or backup utilities that interfere with QuickBooks operations.Symptoms of QuickBooks Automatic Backup Not Working:No backup files are created at the scheduled times.Error messages or notifications indicating backup failures.Manual attempts to initiate backup result in errors or unexpected behavior.Solutions to QuickBooks Automatic Backup Not Working:Verify Backup Settings: Review the backup settings within QuickBooks to ensure they are configured correctly. Check the backup schedule, destination folder, and any other relevant settings to confirm they match your requirements.Check Network Connectivity: Ensure that the computer running QuickBooks has a stable and reliable network connection. Troubleshoot any network issues that may be causing interruptions or delays in the backup process.Free Up Disk Space: Check the available disk space on the drive where QuickBooks saves backup files. Delete any unnecessary files or move existing backups to a different location to free up space. Consider increasing the storage capacity if disk space is consistently low.Repair QuickBooks Installation: If QuickBooks is experiencing issues due to a corrupted installation, repair the installation using the QuickBooks Install Diagnostic Tool or by reinstalling QuickBooks. This can help resolve any underlying software issues affecting the automatic backup feature.Disable Conflicting Software: Temporarily disable or adjust settings for any third-party software that may be interfering with QuickBooks operations. This includes antivirus programs, firewalls, or backup utilities that may be blocking or interrupting the backup process.Manually Initiate Backup: If automatic backups are not working reliably, manually initiate backups from within QuickBooks as a temporary workaround. This ensures that you have recent backup copies of your company file until the automatic backup feature is restored.Conclusion:QuickBooks Automatic Backup is a valuable feature that helps protect your financial data from loss or corruption. However, when this feature is not working correctly, it can jeopardize the integrity of your backups and leave your data vulnerable. By identifying the possible reasons for automatic backup failures and implementing the solutions outlined in this article, you can ensure that your data remains safe and secure in QuickBooks. Regularly monitor backup processes and address any issues promptly to maintain data integrity and peace of mind. Read More
Multiplication with Formulas and VLookup incorrect
I have a workbook utilizing VLookup that the results display correctly i.e., 0.53 is the correct answer in the amount column. I want to multiply that against 14 (number of supplement pills). My formula for the total of 0.53 x 14 equals $7.47 but really the answer should be $7.42.
I have a workbook utilizing VLookup that the results display correctly i.e., 0.53 is the correct answer in the amount column. I want to multiply that against 14 (number of supplement pills). My formula for the total of 0.53 x 14 equals $7.47 but really the answer should be $7.42. Read More
Update on Labs Security Impacts (5/3)
Hello TSPs,
As outlined in today’s blog post by Charlie Bell (Executive Vice President, Microsoft Security), Microsoft continues to make security a top priority internally as well as with our partners and customers. Unfortunately, the unintended consequence of this focus continues to impact labs within our training ecosystem. We are keenly aware how these tenant issues are impacting your training business, from reducing the richness of the overall training experience all the way to potentially cancelled classes.
We have updated the previously shared FAQ (attached) to provide additional details and answer your questions. While we’ve reached a resolution in some courses (see below), the larger question regarding when tenant access will be broadly available is still an unknown. As meaningful updates become available, we will share them here on our Training Services Partner Community (Forum).
Today’s update (8 courses):
SC-300: tenants are now being made available to the Authorized Lab Hosters (ALHs). We are working on creating stockpiles to support the quantity of classes
PL-300 & DP-605: ALHs are now offering these labs via their own Azure subscriptions, and not the M365 tenants
PL-100, PL-900, PL-7001, PL-7002, PL-7003: Skillable has created an M365 tenant solution which is now available to TSPs
Our team is working hard behind the scenes to reinstate tenants or create workarounds for all impacted courses. If you have further questions, please post them via this thread.
Thank you for your partnership,
Dan
Hello TSPs,
As outlined in today’s blog post by Charlie Bell (Executive Vice President, Microsoft Security), Microsoft continues to make security a top priority internally as well as with our partners and customers. Unfortunately, the unintended consequence of this focus continues to impact labs within our training ecosystem. We are keenly aware how these tenant issues are impacting your training business, from reducing the richness of the overall training experience all the way to potentially cancelled classes.
We have updated the previously shared FAQ (attached) to provide additional details and answer your questions. While we’ve reached a resolution in some courses (see below), the larger question regarding when tenant access will be broadly available is still an unknown. As meaningful updates become available, we will share them here on our Training Services Partner Community (Forum).
Today’s update (8 courses):
SC-300: tenants are now being made available to the Authorized Lab Hosters (ALHs). We are working on creating stockpiles to support the quantity of classes
PL-300 & DP-605: ALHs are now offering these labs via their own Azure subscriptions, and not the M365 tenants
PL-100, PL-900, PL-7001, PL-7002, PL-7003: Skillable has created an M365 tenant solution which is now available to TSPs
Our team is working hard behind the scenes to reinstate tenants or create workarounds for all impacted courses. If you have further questions, please post them via this thread.
Thank you for your partnership,
Dan Read More
What to Do When Getting QuickBooks error 6000 1074
QuickBooks is an indispensable tool for businesses, simplifying financial management and streamlining accounting processes. However, like any software, it can encounter errors that disrupt workflow and cause frustration. One such error is QuickBooks Error 6000 1074, which can arise due to various reasons. In this article, we’ll delve into the causes, symptoms, and solutions for this error to help you resolve it efficiently.
What is QuickBooks Error 6000 1074?
QuickBooks Error 6000 1074 is a company file error that typically occurs when users try to open a company file in QuickBooks Desktop. It indicates that QuickBooks is unable to access the company file, leading to disruption in operations. This error can prevent users from accessing their financial data, thereby hindering crucial accounting tasks.
Causes of QuickBooks Error 6000 1074:
Corrupted Company File: One of the primary reasons for this error is a corrupted company file. Corruption can occur due to various factors such as improper shutdowns, network issues, or malware.
Incorrect Folder Permissions: Insufficient permissions for the folder containing the company file can also trigger this error. QuickBooks requires specific permissions to access and modify company files. If these permissions are not set correctly, it can lead to error 6000 1074.
Damaged Network Data Files: Issues with network data files, such as the .ND or .TLG files, can result in QuickBooks errors. These files facilitate multi-user access to the company file, and any damage to them can cause errors during file access.
Outdated QuickBooks Version: Using an outdated version of QuickBooks can also contribute to errors. Intuit regularly releases updates and patches to fix bugs and enhance performance. Failure to update QuickBooks can leave you vulnerable to various errors, including error 6000 1074.
Symptoms of QuickBooks Error 6000 1074:
Inability to open the company file.QuickBooks freezes or crashes when attempting to access the company file.Error message prompts displaying “Error -6000, -1074” or similar.
Solutions to QuickBooks Error 6000 1074:
Run QuickBooks File Doctor: Start by running the QuickBooks File Doctor, a diagnostic tool designed to identify and fix file-related errors in QuickBooks. This tool can automatically detect and repair issues with company files, network connectivity, and folder permissions.
Verify Folder Permissions: Ensure that the folder containing the company file has the correct permissions set for all users. You can adjust folder permissions through the Windows File Explorer by right-clicking on the folder, selecting “Properties,” and navigating to the “Security” tab.
Rename .ND and .TLG Files: Renaming the network data (.ND) and transaction log (.TLG) files associated with the company file can sometimes resolve errors. QuickBooks automatically recreates these files when you open the company file. Locate these files in the same directory as your company file and add “.old” to their file extensions (e.g., company_file.qbw.nd.old).
Update QuickBooks: Ensure that you are using the latest version of QuickBooks Desktop. Check for updates within QuickBooks by navigating to the “Help” menu and selecting “Update QuickBooks Desktop.” Download and install any available updates to patch known issues and improve compatibility.
Restore from Backup: If the above steps fail to resolve the error and you have a recent backup of the company file, consider restoring the backup to a previous working state. This can help eliminate any corruption or data integrity issues causing the error.
Conclusion:
QuickBooks Error 6000 1074 can disrupt your workflow and impede critical accounting tasks. However, with the right troubleshooting steps, you can effectively diagnose and resolve this error. By understanding the causes, symptoms, and solutions outlined in this article, you can minimize downtime and ensure smooth operation of QuickBooks for your business.
QuickBooks is an indispensable tool for businesses, simplifying financial management and streamlining accounting processes. However, like any software, it can encounter errors that disrupt workflow and cause frustration. One such error is QuickBooks Error 6000 1074, which can arise due to various reasons. In this article, we’ll delve into the causes, symptoms, and solutions for this error to help you resolve it efficiently.What is QuickBooks Error 6000 1074?QuickBooks Error 6000 1074 is a company file error that typically occurs when users try to open a company file in QuickBooks Desktop. It indicates that QuickBooks is unable to access the company file, leading to disruption in operations. This error can prevent users from accessing their financial data, thereby hindering crucial accounting tasks.Causes of QuickBooks Error 6000 1074:Corrupted Company File: One of the primary reasons for this error is a corrupted company file. Corruption can occur due to various factors such as improper shutdowns, network issues, or malware.Incorrect Folder Permissions: Insufficient permissions for the folder containing the company file can also trigger this error. QuickBooks requires specific permissions to access and modify company files. If these permissions are not set correctly, it can lead to error 6000 1074.Damaged Network Data Files: Issues with network data files, such as the .ND or .TLG files, can result in QuickBooks errors. These files facilitate multi-user access to the company file, and any damage to them can cause errors during file access.Outdated QuickBooks Version: Using an outdated version of QuickBooks can also contribute to errors. Intuit regularly releases updates and patches to fix bugs and enhance performance. Failure to update QuickBooks can leave you vulnerable to various errors, including error 6000 1074.Symptoms of QuickBooks Error 6000 1074:Inability to open the company file.QuickBooks freezes or crashes when attempting to access the company file.Error message prompts displaying “Error -6000, -1074” or similar.Solutions to QuickBooks Error 6000 1074:Run QuickBooks File Doctor: Start by running the QuickBooks File Doctor, a diagnostic tool designed to identify and fix file-related errors in QuickBooks. This tool can automatically detect and repair issues with company files, network connectivity, and folder permissions.Verify Folder Permissions: Ensure that the folder containing the company file has the correct permissions set for all users. You can adjust folder permissions through the Windows File Explorer by right-clicking on the folder, selecting “Properties,” and navigating to the “Security” tab.Rename .ND and .TLG Files: Renaming the network data (.ND) and transaction log (.TLG) files associated with the company file can sometimes resolve errors. QuickBooks automatically recreates these files when you open the company file. Locate these files in the same directory as your company file and add “.old” to their file extensions (e.g., company_file.qbw.nd.old).Update QuickBooks: Ensure that you are using the latest version of QuickBooks Desktop. Check for updates within QuickBooks by navigating to the “Help” menu and selecting “Update QuickBooks Desktop.” Download and install any available updates to patch known issues and improve compatibility.Restore from Backup: If the above steps fail to resolve the error and you have a recent backup of the company file, consider restoring the backup to a previous working state. This can help eliminate any corruption or data integrity issues causing the error.Conclusion:QuickBooks Error 6000 1074 can disrupt your workflow and impede critical accounting tasks. However, with the right troubleshooting steps, you can effectively diagnose and resolve this error. By understanding the causes, symptoms, and solutions outlined in this article, you can minimize downtime and ensure smooth operation of QuickBooks for your business. Read More
Dev Channel update to 126.0.2552.0 is live.
Hello Insiders! We released 126.0.2552.0 to the Dev channel! This includes numerous fixes. For more details on the changes, check out the highlights below.
Added Features:
Implemented a mute button on the taskbar.
The capture menu toolbar has been added to the PDF file.
Improved Reliability:
Fixed an issue where the browser would crash when users clicked on ‘Leave workspace’.
Fixed a browser crash on android.
Fixed an issue that caused the browser to crash upon closing the final tab.
Changed Behavior:
Resolved an issue where the share box would briefly appear blank and then vanish after a few seconds.
Fixed an issue where tabs that had been deleted reappeared after restarting.
Resolved a problem where there were visual style discrepancies on the product detail page, including issues with margins, colors, border radius, and shadows, within the extension.
Resolved a problem that caused visual distortions when tabs were grouped in a vertical layout.
Fixed an issue where horizontal scroll bar and vertical bar appeared in FRE.
The issue where the side pane would unexpectedly open after FRE has been resolved.
Fixed an issue where the page at edge://settings/appearance/CustomizeToolbar was displaying as blank.
Fixed an issue that prevented the sharing of screenshots via Outlook.
iOS: Fixed an issue where the string in the toolbar settings page needed to be changed.
Mac: Resolved an issue where the Send Feedback feature initially displayed a blank screenshot. Subsequent attempts would then show the previously captured screenshot on Mac.
Android:
Resolved a problem where the keyboard focus was not moving to the ‘Earn More Rewards’ link within the Microsoft Rewards section on Android.
Fixed an issue when altering the background color, the page no longer flashes on Android.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri
Hello Insiders! We released 126.0.2552.0 to the Dev channel! This includes numerous fixes. For more details on the changes, check out the highlights below.
Leading in the era of AI: How Microsoft’s platform differentiation and Copilot empowerment are driving AI Transformation – The Official Microsoft Blog
Added Features:
Implemented a mute button on the taskbar.
The capture menu toolbar has been added to the PDF file.
Improved Reliability:
Fixed an issue where the browser would crash when users clicked on ‘Leave workspace’.
Fixed a browser crash on android.
Fixed an issue that caused the browser to crash upon closing the final tab.
Changed Behavior:
Resolved an issue where the share box would briefly appear blank and then vanish after a few seconds.
Fixed an issue where tabs that had been deleted reappeared after restarting.
Resolved a problem where there were visual style discrepancies on the product detail page, including issues with margins, colors, border radius, and shadows, within the extension.
Resolved a problem that caused visual distortions when tabs were grouped in a vertical layout.
Fixed an issue where horizontal scroll bar and vertical bar appeared in FRE.
The issue where the side pane would unexpectedly open after FRE has been resolved.
Fixed an issue where the page at edge://settings/appearance/CustomizeToolbar was displaying as blank.
Fixed an issue that prevented the sharing of screenshots via Outlook.
iOS: Fixed an issue where the string in the toolbar settings page needed to be changed.
Mac: Resolved an issue where the Send Feedback feature initially displayed a blank screenshot. Subsequent attempts would then show the previously captured screenshot on Mac.
Android:
Resolved a problem where the keyboard focus was not moving to the ‘Earn More Rewards’ link within the Microsoft Rewards section on Android.
Fixed an issue when altering the background color, the page no longer flashes on Android.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri Read More
All about SQL drivers and access tokens
We often get support escalations related to failures around expired access tokens when using Microsoft Entra ID (formerly Azure Active Directory) authentication. There is a lot of nuance in the various drivers about how and when access tokens are used and when they get renewed after expiring. I’m going to do a deep-dive and try to explain some of the details here.
This post is mainly targeted at people who have to troubleshoot issues in this area or those who are building large services and need to understand the impact of their authentication choices.
The Problem
Errors related to expired access tokens usually involve an error like “Login failed for user ‘xxxxxx’.” (Pretty generic and unhelpful. Security minded folks don’t want to give potential attackers clues when authentication fails.) The error could happen either on connection open or statement execution.
Background
Connections to SQL use the MS-TDS protocol and it’s important to keep in mind that TDS is a stateful connection. Meaning the client authenticates at the beginning of the connection and the connection is maintained until the client closes it. There is no mechanism to re-authenticate (send a new access token) in TDS at any point other than at the beginning of a connection. Applications can execute many queries over long periods of time while the connection is open. Opening a connection and authenticating is also a relatively expensive operation. So, connection pools are often used to maximize performance, keeping connections open for a relatively long period.
Connection pools return a “logical” connection to applications that open a new connection. Each logical connection is serviced by a “physical” connection from the connection pool. When a logical connection is “closed” by the application, the physical connection is returned to the pool but remains open behind the scenes.
Obviously, the database validates access tokens when a connection is first opened. Another common point when tokens are validated is on a RESETCONNECTION event. A RESETCONNECTION event happens when a driver sets the RESETCONNECTION status in the next packet header. This is meant to be used in the context of connection pooling. A driver can set the flag in the header of the next statement execution on a logical connection coming out of a pool. When the server sees that status, it resets the environment prior to executing the statement. This helps prevent “dirty” physical connections from impacting different logical connections. It also helps prevent connection pools from persisting connections for security contexts that no longer should have access to the database. For example, you wouldn’t want a security context whose access has been revoked to continue to be able to create new logical connections. Relatedly, if an access token is near expiration or expired, a driver can close a physical connection from the pool instead of reusing it since an expired token would result in an error. It can then open a new physical connection with a new token to service the new logical connection request.
Speaking of connection pooling, not all drivers do connection pooling the same, so clarifying how connection pooling works is relevant to access tokens.
ODBC: Connection pooling in ODBC is handled by the ODBC driver manager, which is what is responsible for loading the correct ODBC driver requested by the application. The ODBC driver manager signals an ODBC driver when a connection is going into and out of the connection pool, so the ODBC driver for SQL Server knows when to set the RESETCONNECTION status. At the same time, it also knows if it needs to obtain a new access token and open a new connection on this event.
JDBC: In JDBC, connection pooling is handled by 3rd party libraries. There are connection pool specific JDBC classes that need to be used by the connection pool library. Those classes include APIs to let a driver know when a connection is going into or out of a connection pool. This signal is required for the driver to be able to set the RESETCONNECTION status. Unfortunately, not all connection pool libraries utilize those classes. HikariCP is the most notable one here that doesn’t use them. The implication is that, if you are using HikariCP, connections will live as long as their max lifetime as defined in HikariCP. You’ll need to manage that lifetime relative to the access token lifetime. Additionally, if an application encounters the “Login failed for user ’xxxxxx’.” error, the application or the connection pool will need to ensure the underlying connection is closed so that it isn’t reused by a subsequent connection request. This issue can be alleviated by adding a validation query to the connection pool settings that is run before the pool hands the connection out. This does come with a small performance penalty, though.
(Sidebar: HikariCP and others offer a lot of knobs to tune your connection pool. Don’t overload your authentication server with those settings. For example, say you have a microservice architecture with 200 nodes. Each node has its own connection pool with a minimum of 30 connections and a 20 minute connection lifetime. You’ll be hitting your authentication endpoint with an average of 200n * 30c / 20m = 300 requests per minute. Not necessarily spaced evenly over each minute because each set of 30 connections per node will be renewed simultaneously. You will most likely see intermittent authentication failures, if you do something like this. If you use the built-in authentication methods, the driver will try to serialize the authentication attempts and cache the access token for reuse. But this is not guaranteed across all versions.)
.NET: SqlClient (specifically, System.Data.SqlClient, or SDS, and Microsoft.Data.SqlClient, or MDS) implements connection pooling internally. It also uses the RESETCONNECTION status to indicate a connection coming out of a pool. If the pool uses token-based authentication, SqlClient will check the expiration date of the token before handing the connection to the application. If the token is expired or close to it (10 minutes), all connections in the pool are recycled and a new connection is created with a new token. All connections in the pool reuse the same cached token.
This all works pretty well when using the built-in token authentication methods (Authentication=ActiveDirectoryXXX). But let’s talk about access tokens passed from the application.
The SQL drivers also have a connection property that allows an application to pass an access token to them one way or another. What is the implication when applications do this? Well, that access token doesn’t have expiration information with it (at least not the part that is handed to the driver). This means the driver doesn’t know if a token is expired. You need to carefully manage connection lifetime in this scenario. If a connection is taken from a pool with an expired access token and the server sees RESETCONNECTION in the header, the server will validate the access token before executing the query that’s being sent (remember, we said above that RESETCONNECTION is sent in the header of the next statement execution). This will result in an execution error that the application will need to handle. This won’t invalidate the connection so it’s important that applications recognize this and stop using the expired token or the error will simply keep repeating as long as pooled connections persist. To correct the situation at runtime, the application will need to obtain a new token and create a new connection with the token. This creates a new pool because when the application passes the access token, the token is part of the pool key (it’s not part of the pool key when using the built-in methods). If you are using a driver that allows you to specify a minimum connection pool size, be sure to clear any pools using expired tokens in this scenario, or you might find them lingering forever (essentially a memory leak).
In the Microsoft JDBC Driver 12.4 for SQL Server, we’ve added an AccessTokenCallback on the connection to address this drawback of the AccessToken property. The MDS library added the same thing in 5.2. The callback allows the application to provide an access token and its expiration whenever the driver needs it.
All that said, I’ve heard of instances where customers say long running sessions (with lots of statement executions) result in token expired errors (Login failed for user ‘xxxxxx’. A severe error occurred on the current command. The results, if any, should be discarded.) on statement execution. However, after explaining the above, they usually go silent. I can’t tell for sure if the server might be validating access tokens on a query execution without RESETCONNECTION, or if they realize they are in one of the above scenarios. (The error and stack trace will be the same.) But the more you know, the easier it will be to figure out where the problem lies.
David Engel
Microsoft Tech Community – Latest Blogs –Read More