Forum Widgets
Latest Discussions
"File not found" error (Error 53) when opening Access database
I'm getting a "File not found" (Error 53) error when trying to open an Access database (.accdb file). The error appears during the database startup process and points to a VBA subroutine declaration line: The error message mentions "The file was not found where specified" which suggests VBA is looking for a file during project compilation, but I can't identify what file it's looking for. Has anyone encountered this issue where the same Access file works with some SQL Server backends but fails to even open with others?
Attachment.Add issue
I have the following sub routine Private Sub Command6_Click() Dim Msg As String Msg = & ",<P> Please find attached the quote you requested." Dim O As Outlook.Application Dim M As Outlook.MailItem Dim Brochure As String Set O = New Outlook.Application Set M = O.CreateItem(olMailItem) If Option1 = -1 Then OrderEntryProcedure = "File location" With M .BodyFormat = olFormatHTML .HTMLBody = Msg .To = "email" .Subject = "Test" .Attachments.Add OrderEntryProcedure .Display End With Set M = Nothing Set O = Nothing End Sub My problem is that I cannot return a null value for OrderEntryProcedure which is often the case. As far as I can tell the Attachments.Add must have a value. What type of work around exists so that I can simply not attach a file to the email if Option1 is <> than -1?
3044 error in Access
I have two computers networked Windows 10 together and have moved to two new computers windows 11. I have also moved from Microsoft 365 to 2024 office professional plus. Everything seems to work on the new computers except one Access database. That file has a front and back built in. I get a 3044 run error and the data base will not open. The error says it can not find the data base. I think in the transfer the old computer may have a different name than the new, It appears that is the problem. In the network I can see both new computers, it seems they are set up correctly but that could be a problem as well. I simply do not know how to fix it. I hope someone here may have a solution.Should be easy...... Open a form to a specific record
I have a form with rows showing individual audit for staff members. Each audit would be individualized by an Autonumber ID field. I want the user to be able to click on the ID field, have it close the form, and open another form on that specific record. Both forms are based on the same underlying table. The VBA I'm trying is the following: Private Sub ID_Click() DoCmd.OpenForm "Case_Notes", acNormal, "[ID] = " & Me!ID DoCmd.Close acForm, Me.Name, acSaveNo End Sub It does open the other form, close the form the user is clicking from, but it does not go to the ID number I click. For example, I click on ID 3, and the other form opens on ID 2. Any help would be greatly appreciated! Let me know if you have questions that I haven't clarified.
Access Northwind Dev Ed - Error GetRandomPkValue
Just downloaded the newest MS Access and selected a new Northwind Dev Ed as the first DB to create. It fails to open due to an error in the code as it searched for a non existing function GetRandomPkValue... The purpose of the missing function is to return a random primary key value by passing in the variables for a query name and a field name and then it should return a "random" numerical ID from those possible based upon the passed in variables... My question is, Is the new Northwind Dev designed to fail on purpose or did I manage to download a corrupted incomplete version or???ODBC call failed. ORA-01406
Trying to link to tables on our server which has never been an issue. ODBC connection is fine, using Driver Oracle in OraClient 11g_home 1. Selecting Data Source ODBC Database and selecting Link to the data source by creating a linked table. At this point it asks for a password which is typical, next it would normally bring up the list of tables in the Oracle database to link to. Instead I get the error which states "fetched column value was truncated", once I hit OK to clear the error the usual window appears where I would see all the available tables to link to but no tables are listed, it's blank.
Microsoft Access and Outlook
Hi there, I have just updated my laptop (with a view for a faster laptop!) However, Access was working fine and now i can't send emails from access through outlook like before. I get a message to say a program is trying to send an email message on your behalf. I'm not sure how to get rid of this warning! Please help.... Thank you in advance
I can't access Microsoft Feedback Portal: account bug
I changed my Microsoft email a year ago, and it updated everywhere other than the Feedback Portal. As a result, I get an error when I try to login, or do anything on the page. Microsoft account support's suggestion was to login to the Feedback Portal which is insane given I'm having issues accessing it. How can I get this issue resolved? I've got three separate support tickets now and they keep asking me to wait 24 hours to get the issue resolved. Can someone from the Feedback Portal team please contact me to resolve this? This is what Microsoft Support have said: "understand your frustration, and yes—this is an account‑related issue because the Feedback Portal is still tied to your old alias, which causes login conflicts and forces you out. Your Microsoft account itself signs in correctly, but the Feedback Portal is pulling outdated identity data that you cannot update on your own. Since you cannot access the Portal to submit feedback, directing you back there is not a workable solution. What you need is for Support to escalate this to the internal Identity/Feedback Platform engineering team so they can manually correct the outdated alias mapping on the backend. In this situation, the Feedback Portal and Tech Community teams are the ones who manage and maintain that specific platform. Because the issue appears on the Feedback Portal side—even though your Microsoft account is working normally—only their dedicated team can make the necessary corrections on their end. That’s why we are guiding you to connect with them through the links provided: https://techcommunity.microsoft.com/ or https://feedbackportal.microsoft.com/feedback. They will be able to review the portal‑specific account data and assist you further. I understand why this is frustrating. Since you’re unable to stay signed in to the Feedback Portal, I completely see why posting there isn’t possible for you. However, I do need to be transparent: I’m not able to escalate this issue directly to the Feedback Portal team, as they don’t provide internal escalation channels for us and only accept requests through their own platform."
