MS Access passthrough query performs very slow when executing a stored procedure
I have a passthrough query in my Access frontend that I use to import data from a sql server db. I work with MS 365 MSO Version 2302 32 Bit. Before executing the passthrough query I pass the connectionstring and the sql to the querydef object and then I pass the output to a DAO recordset: Set qdf = CurrentDb.QueryDefs("myPTQuery") qdf.Connect = myconnectionstring qdf.SQL = "EXEC MyStoredProc " & param1 & ", " param2 Set rstDAO = qdf.OpenRecordset When I execute the stored procedure in SSMS using the same parameters it takes 2 seconds. In MS Access I need to set the ODBCTimeout parameter to 4 minutes to avoid a timeout error. This problem occures rarely, i.e. only under certain parameters. But I cannot figure out any significant difference between the cases the passthrough query performs well and the ones it doesn't. It seems like the timeout occures regardless on which parameters are passed to the stored proc. It worked before. Could it be caused by some office update? Any ideas on how to improve the performance of the passthrough query?
Multiple Bookings Issues
Lately I have had issues seeing details under a book, it will give me the title but nothing else. This only happens on the web version of bookings. If I use bookings under teams app it works fine. Not able to view information, not able to edit bookings, "All Day" times are offPacote Office Online com problema
Boa tarde, hoje pela manhã fui abrir o word online como sempre faço, porém dessa vez quando abri só apareceu a aba de modelos de documentos e a opção de criar um novo documento. A parte de baixo onde mostra os arquivos recentes, favoritos, compartilhados e criados acabou sumindo, essa parte não existe mais e não consigo clicar para criar um novo arquivo, ele não ativa a ação. Fiz uma assistência remota com um dos assistentes da microsoft para verificar o problema, mas sem sucesso, por isso venho pedir ajuda de você engenheiros para reolver meu problema, porque eu uso essa ferramenta todos os dias para trabalhar. Poderia me ajudar por gentileza? Obrigada desde já!Bug report | Unexpected mails received by users saying their reservation is canceled ... but is not
Hi everyone, We are using internally in my company Microsoft Bookings in order to get a physical slot in our building. But recently, after no issues during months, some persons starts receiving mails saying that their reservations is canceled. No action was done by administrators, and they are still display in the slot on admin side. So the problem is only on the communication done automatically. We started to see this problem this week or end of last week. Do you have any clues? Thanks, Thomas
