After updating Access in Office 365 to version 2408, the MSACCESS.EXE process remains after exiting Access.

Hi,

Thank you for your efforts, but I think I (or my environments) are just not authorised/eligible for the bug. ;-)

In both Access versions that I mentioned I get

Open Databases : 2

No problem with 3048, no problem with a hanging process.

Servus
Karl
****************
Access Forever, News, DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

Hi Kal,

I have just re-rolled forward to 2408 to create you a test scenario. Microsoft® Access® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 32-bit

If you run the ReproduceError() function on an affected system then it will output as follows : "Open Databases : 1" "Open Databases : 2" "Open Databases : 3" etc. When it reaches 504 it is game over.

On an un-affected system

Microsoft® Access® for Microsoft 365 MSO (Version 2406 Build 16.0.17726.20078) 32-bit

it will output "Open Databases : 1" "Open Databases : 1" "Open Databases : 1" 5000 times, as it should.

Function OpenDatabaseCount() Dim td As TableDef
For Each td In CurrentDb.TableDefs

    'Do nothing
Next
OpenDatabaseCount = DAO.Workspaces(0).Databases.Count

End Function

Function ReproduceError() Dim i For i = 1 To 5000

Debug.Print "Open Databases : " & OpenDatabaseCount

Next End Function

Hi,

Thanks for your repro steps. Unfortunately, they don't work for me.

1. I see v3.16 in both versions of Colin's tool (accdb and mdb) after the download.
2. In my M365 version 2408 17928.20114, 64-bit neither the simple repro nor the one with some thousand additional records in a linked table use up any connections. Note the different bitness.
3. The only 32 bit version I have in the moment is Access 2016 version 2408 17928.20114. Same result there.

So, I'm still not able to reproduce the problem.

Servus
Karl
****************
Access Forever, News, DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

Olá pessoal,

Estava com esse problemas a dias. Não estava entendendo pois nos meus clientes tudo estava funcionando.

Porém, quando vi comentários sobre o problema da nova versão, procurei achar soluções para o problema e me deparei com o site https://www.devhut.net/another-msaccess-exe-process-not-closing-properly-bug/ onde, não opção 2, é orientado a criar um local confiável para a pasta onde se encontra o seu ACCDB.

Fiz isso e tudo voltou a funcionar sem precisar voltar versão. Muito legal!

Tentem ai !

Abraços

Hi affected people,

The simple reproduction steps in the initial post here never have worked for me. I've also tried to get 3048 or a hanging background process with a few thousand records, with different databases, with Northwind, all without "success".

Can anyone here provide a reliable repro scenario or better yet a database where the error and/or hanging process reliably occurs?

This would be very helpful in discussions with Microsoft.

Servus
Karl
****************
Access Forever, News, DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

3048 Error Reproduction

Microsoft Access for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 32-bit

Simple Reproduction with database:

1. Download and open this: Available Connections (isladogs.co.uk) and notice every refresh(10 seconds by default) that 2 more connections are used up and not returned to the pool/garbage collected.

There are two calls to CurrentDB each refresh, the expectation is that the calls to CurrentDB should be auto garbage collected. They are not.

This causes the pool to empty and when you exit, the references are left open.

If you change the CurrentDB to an object and call close on it, you won't have any leaks and Access may (or may not) close properly.

----------------------- OLDER INFORMATION BELOW--------------

1. Create new database A with Table1
2. Create new database B with Table2
3. In Database A, link Table2 ( External Data -> New Data source -> From Database -> Access -> Link to the data source by creating a linked table )
4. In Database A use this: Available Connections (isladogs.co.uk) and notice every refresh(10 seconds by default) that 2 more connections are used up and not returned to the pool/garbage collected

• To make it worse, have a large table and create a continuous form that has a field that uses a function that calls CurrentDB
• This also creates the hanging background process.
• Further testing I've done shows that if you call .close after every usage of CurrentDB, it seems to properly clean up after itself and you'll get no leaks (in *your* code). But you need to manually close each usage of CurrentDB, the garbage collector doesn't seem to do it.

(Note, I don't know why the form says v3.14 at the bottom when it's in the download for 3.16 on the site)