Forum Widgets
Latest Discussions
Moving Away from MS Access
The organization I work for is wanting to move away from Microsoft Access databases where possible, and we have started exploring what tools our current Access databases could be moved to. Is there a standard for what works best (Powerapps, Sharepoint, etc)? What have you found to be a good resource for guidance on this topic? Thanks!
Office update 2405 17628.20110 causes slowness in loading forms in MS Access
We experience issues with the May 30 release of Office 365, from version 2405 17628.20110 We experience issues with Microsoft Access. The issue that we experience is that loading and closing of forms takes longer and longer when you are using the application. Basiccally what we see is that the drawing of the form takes longer each time a form is opened. We have written a recursive function to illustrate this: When we execute the function, this are the results: ….. ….. …. In above overview you can see that when we start the access application the loading of the form takes approx. 0,3s, and the closing of the form takes 0,05s After 100 opens the timings are 0,5 and 0,3s After 200 opens the timings are 1,4s and 1s After almost 300 opens the timings are 2+s and 1,8s When we execute this same recursive function in an older version of Microsoft access the timings are stable. We have tested this with several forms. And we see this with all forms. The only difference is the loading speed – which depends on the number of objects that are drawn on the form. The more objects the slower and the higher the increase in becoming slower. Anyone knows if this bug is already reported / fixed by Microsoft?
Please help!!! Run-time error 3828 Cannot reference a table with a multi-valued field ...
I have a form that passes a string to a query. From the form, I want to convert the query results to a csv file. I have checked several posts on this subject and they don't seem to have any problems using the DoCmd statement...I am posting my code below. Private Sub Toggle15_Click() Dim QueryName As String Dim ReportName As String Dim SaveLocation As String Dim DateFormater As String Dim FileNameFormat As String Dim Project As String Dim Location As String QueryName = "qryConvert" DateFormater = Format(Date, "MMDDYY") ReportName = "ICAM Sustainment" FileNameFormat = ReportName & " " & DateFormater & ".csv" Project = DLookup("ProjectDescription", "tbl_Project", "PID =" & ProjectDescription) Location = DLookup("Location", "tbl_Location", "LID =" & SiteLocation) DoCmd.OpenQuery QueryName, acViewNormal, acEdit DoCmd.TransferText acExportDelim, , QueryName, Text24 & "\" & Location & "_" & Project & FileNameFormat, True MsgBox "Export is Complete!" End Sub I can't seem to find out what in the query is the problem. I have a simple query with a lookup function for one value that is passed from a form...to select the records...The pic below shows where the code stops and the error message I get....Run-time error 3828 Cannot reference a table with a multi-valued field using an IN clause that refers to another database. thanks in advance.....
Problem with the MsJet40.dll released with the Windows 10 KB4566782 Update
Hello, We have a problem with the new MsJet40.dll version 4.0.9801.25 released with the Windows 10 KB4566782 Update All "replicated' MDB database can't be open anymore with an error message : " Impossible d'ouvrir la base de données 'MSysAccessObjects'. Ce n'est peut-être pas une base de données que votre application reconnaît, ou le fichier est peut être endommagé " (Sorry In french) When I revert to msjet40.dll version 4.0.9801.20 the database can be openned again I hope you can repair this problem. We are still using msaccess 2000, but I think this is a problem with all version using Jet engine Regards, Dan
