Check is someone has linked to a database (1 Viewer)

Afternoon All

Not sure this is possible, lets say:

- I have a backend database (local tables)
- Someone links to the table so they now see the data in the local tables

Is it possible to see if anyone has linked to them?

I understand the database can have a password which can put a stop to this, but in the interim I want to know if someone's connected to them

Thank you in advance

Hi. This is a little old but it might still work. By the way, you can only tell who is currently connected (linked) to your data. You won't be able to tell who linked to your data if they're not currently using or viewing the data.

You can only see links when they are active. There is no history once the .ldb or .laccdb has been deleted and that happens when the last person closes the app which might happen dozens of times per day if you don't have a large number of active users.

I have an old copy of a tool. There might be a newer version available so use the link in the documentation to see if one exists.

You need to change the file type to .accdb when searching for a file if that is the BE type you are using.

Following on from the previous reply, here is an updated version of David Crake'e utility showing who is connected to an application. It works in both 32-bit and 64-bit Access
See https://www.access-programmers.co.uk/forums/showthread.php?t=295174.
It also works with password protected databases.
Hope that helps