Database in an "inconsistent state" and other errors
Hello. I was directed here for help by Microsoft Tech Support because the problem is "file specific" and not at the app level. I am not computer savvy and have never used a forum like this. Tech support just kind of dumped me here and said "have at it," so any guidance, help, etc. would be appreciated. I use Microsoft Office 365 as a personal/individual subscriber and my Access program started issuing error message over the past week. The biggest concern and problem is around db called Comic Books and I've attached the error message. When I click OK, it attempts to repair, fails and issues the second message. Another database--an earlier copy of Comic Books from mid December-- opens OK, but has its own problems, such as when I attempt to simply copy a table (see third error message). I don't know if these are related. Can anyone help me? Is there any hope for me ever regaining access to the Comic Books database which was last accessible and working on January 4? Thank you.
No labs for MB-500 in skillable and xtreme labs (for all MB series)
Hi, From past few months, we are unable to find the labs for MB-500. It's causing us trouble to do the trainings. Skillable and Xtreme labs providers are saying there is a problem from Microsoft end only. Kindly advise us when can we get the labs available.
Third-party access via Organisational Link
Hi, Previously when logging into my personal account on a Web Browser, it flashed up with what is the typically an organisational message about an IT administrator. After being ping-ponged back and forth from the Microsoft Support teams, it's been suggested there is an organisational link with my personal email account, which absolutely should NOT be the case. My concern is if someone has linked my email with an organisational account, then they are privy to a lot sensitive information from personal finances to healthcare (this has also correlated with some odd behaviour on certain devices). The agents that I have spoke to have not yet provided me with a viable solution to removing any links to an organisational account, nor getting a list of any organisations or entities that have been linked to my personal account. Does anyone have any ideas as to a way around this? Many thanks.
Access SQL Syntax Highlighting, Autocomplete, and Formatting
I just had Access (the newest version with Office 365) lose all syntax highlighting, autocomplete, and the formatting that had been allowed previously. It worked last night, and this morning it was all gone. The issue is on my Windows 10 desktop. It still highlights syntax and formats for readability on my Win 11 laptop. The only thing I can find between the two versions that is different is there is a checkbox for the Monaco query editor in Access on my laptop, but not my desktop. I would like to reiterate that it was fine last night on the desktop. I opened the same database this morning, and it was gone. I checked other databases, they all lack the highlighting and formatting on my desktop, but it is still there on my laptop. I attempted to update, repair, and reinstall office, and nothing changed. I am trying to determine what might have caused this, and if there is anything to do about it. The highlighting, autocomplete, and formatting are not a complete necessity, but they made working with the queries a lot easier for me, since I am a not particularly experienced with SQL.How do I reference query data from an Access Macro
I have a simple Select query that returns a number of records. In my Access macro (just for clarification, I do mean Access Macro and not VBA) I want to check how many records the query returns in an IF statement. In this specific case the check would be on zero returned records, but being able to check non-zero in the future might be useful. I have tried various internet searches but the only results I found relate to VBA. Suggestions on how to do this check would be appreciated. Thank You
Can't use a SPN in a PowerBi dashboard to access SharePoint lists
Hoping you can help with an ongoing issue I have. I have a PowerBi dashboard I built using regular account to fetch some SharePoint lists and uploaded it to PowerBi for others to view Now in PowerBi portal I want to change the credential from my account to an SPN. I've read what feels like a thousand articles describing the process to create the SPN 99% all the same. Yet when I go into Powerbi portal, edit the semantic model for the dashboard, click edit credentials, select Service Principal put in the tenant ID the Service principal ID (yes using the app id, in fact I tried everything) the service principal key (the secret) and choose any privacy level it fails 100% of the time. Error is: Failed to update data source credentials: The credentials provided for the SharePoint source are invalid. Same error regardless of what privacy level I choose. I'm sure the secret is correct also. Just for fun I tried the Secret ID and the Object ID in place of the Application ID for the Service principal ID field. All failed same error. I'm sure the secret is correct also. The SPN has Graph sites.read.all, Graph user.read and SharePoint Sites.Read.All api permissions configured. All are consented. Everything seems right but gives me the error failed to retrieve oauth token 100% of the time. Am i missing something else? More API permissions maybe? Do i still need ot actually add the SPN to the Sharepoint site itself even though I has API permissions SharePoint Sites.Read.All? I've done days of research and all I find is lots of people with same or similar issue but not resolution. Is this a bug? Help me I'm desperate to get this fixed or I'm going to have to allow people to bypass MFA across my organization which I cant have.
Account blocked
My account has been blocked and when I try to reset my password and do the verification with my phone number, it says it isnt available. I then put in a different email to send the code too and I have filled out the recovery form but it has rejected me, even though, I put all the correct information in. I have tried over and over. Everything comes in to that email so I really need access back for work purposes as well as private. Please can someone help me as I cant speak to a customer support agent!
