Database not closing properly; process still present in task manager. I'm probably missing something

[Enioch]

Hello again, good accesspeople.

I have this access database (too big for the site): https://www.dropbox.com/s/cykuqpzgsk...WIP.accdb?dl=0

It's currently very WIP, and I'm sure there are problems (especially since I haven't touched Access in years and my experience with it has been minimal to begin with), so I'd like some help, as it is giving me some trouble:

Currently, if I close Access, a process remains in use (still visible in the Task Manager). This means that if I double-click the file, it doesn't open Access (or rather it starts a new process in the background, but the GUI never appears). My amateur diagnosis is that I'm not closing the file properly; I've opened / created / coded something that remains working in the background and it prevents the database from closing completely. Add to that the notable bloat that I've seen, and I'm growing suspicious.

The file that you see used to be an 8MB file. I re-imported everything into a new blank file and the DB immediately shrunk to something more realistic (~700KB), but a test run showed already tendencies to bloat up again.



I have tried to compact and repair, but I get a message that "Could not access file XXX (Database path) ; file already in use". That is the case even if I have previously closed all other existing Access processes.

Could the clever people here have a look and let me know what I'm missing, if anything?

The main form is "Ships".

Many thanks, good accesspeople.

[pbaldy]

See if this helps:

https://www.devhut.net/access-lock-file-issues/

I had the same problem, had to revert to a previous version.

[Enioch]

Yup, that bloody well did it. Goddammit, Microsoft , and thanks a lot pbaldy!

Out of curiosity, and with regards to the bloating - is that normal for Access, or am I doing something wrong in my code?

I read in various places on the webz that I should be closing things and / or setting them to "nothing", but I don't see where that would go in my code (or if it's even necessary, given how I've written it).

[June7]

Access VBA discards object variables when procedure ends but doesn't hurt to explicitly close/set. See examples in

http://allenbrowne.com/ser-23a.html

http://allenbrowne.com/func-DAO.html

[pbaldy]

Bloating can result from append and make table queries, etc. A compact/repair will usually bring the file size back down.