Recent content by vxr

I have figured out what causes this issue. If you have open a Database or a Recordset in VBA and do not close it. This will keep the connection open. You need to do rs.close AND db.close. Usually Access handles these and closes them by itself. I figured it this out because I had a function...

I made a batch file and placed it in the network drive to kill MSAccess task. I told everyone if they can't open access to run the file first. If anyone is interested: taskkill /F /IM MSACCESS.EXE

I am on 2408 build 17928.20114. Effected systems are both windows 10 and 11 pro. Repairing access and then updating brings me back to version 2402 Build 17328.20550 and I am unable to update past that and the issue is resolved. Maybe they removed the subsequent update? I really don't want to...

Hello all, last week I noticed access not closing on two different PCs. I was able to resolve this with "online repair" followed by office update. Today the issue is wide spread. Anyone else experiencing this? Thanks

I am just trying to preview a local PDF.

I am the same except running 32-bit.

Hello All. I am on version 2312 Build 17126.20132. Edge browser still not working. It works only on one PC that I have downgraded to an older version. According to this thread, it should be resolved, no? Thanks

My understanding is that you can't use switches directly with GPO. You need an .MST file to transform the package. "Windows SDK components for Windows Installer developers" has a program Orca that is supposed to facilitate this but every link on MS site kept hitting me with an error saying I...

Thanks, I 100% agree! I saw that 18 was out but for some reason it wouldn't work. I didn't try to troubleshoot it as I just wanted to resolve the issue ASAP. When I have some time I will work on it. Hopefully I can figure out how to push it via GPO.

I appreciate the update. Personally pushed out ODBC Driver 17 for SQL Server. Unfortunately I couldn't Assign it by GPO because the MSI requires iacceptmsodbcsqllicenseterms=yes. I tried to get Orca to create an MST file, but I couldnt find anywhere I could download the MS SDK. I figured it...

Yes, I had that suspicion too, but I am not sure that is the case. On the PC that I rolled back to Version 2310 (Build 16924.20124), I only have one SQL connection type available and that's the "SQL Server". But what's interesting is it is dated as 1/8/2024. I'll update that PC back to the...

That's awesome, I appreciate the test. Just one thing I noticed. The "SQL Server Driver" is dated as 12/13/2023 The "ODBC Driver 17 for SQL Server" is dated as 12/20/2022 Meaning the "Driver 17" is older

@cheekybuddha Resolved: That link helped me although I might not have the exact issue. For years I have been using the SQL Server driver. I Re-linked using "ODBC Driver 17 for SQL" and the issue has been resolved. (previous MS Access build didn't care) Previously the SQL Connection String...

As far as I know, someone in the office said it started occurring yesterday. I checked "Start >> Settings >> Update and Security >> Update History" and i doesn't show office updates only Windows. I read somewhere to check the date modified for WinWord to determine when update occurred and it...

Sorry, I meant to include it but got distracted: Version 2312 (Build 17126.20132) - Slow/hangs Version 2310 (Build 16924.20124) - No issues One way to replicate this issue is to open a large table and try to go to the last record or create a new record.