Someone is blocking my database.

[petertenthije]

Good morning,

I've got a database that serves as a back-end for various files on the internal netwerk. Both Excel and Access files are linked to this back-end.

Someone is now blocking the database. Is there a way for me to tell who is doing so, or what file is doing so?

It does not appear to be another Access file, because there is no LACCDB file available. Therefor I assume it to be an Excel file that has the wrong connection settings (eg Share deny write or readwrite)

 

[ranman256]

what do you mean 'blocking' ?

 

[petertenthije]

When I open the database you get the yellow status bar with a notification that the database is already in use.

 

[JonXL]

When I open the database you get the yellow status bar with a notification that the database is already in use.

I'm not familiar with this. Can you post a screenshot?

 

[petertenthije]

I'm not familiar with this. Can you post a screenshot?

Not at the moment. The error has gone away.
Presumably, whoever was blocking the database has closed the file that did so.

I will keep an eye on it. Since the root cause has not been established, chances are it will happen again in the next few days.

 

[AtlantaAccessAndExcel]

You can use the Resource Monitor to find out what user/process has the file blocked.

Go here for instructions:

How To Know Which Process is Using a File or Folder in Windows | Dariawan

How To Know Which Process is Using a File or Folder in Windows

www.dariawan.com