Prev: data base read-only
Next: Sharepoint 2007 lookup field showing up as memo in Access 2003
From: DianePDavies on 24 Feb 2010 10:17
How can I easily see who is using the backend database?

I can tell from the presence of a ldb-file that it is in use - but I dont
know by who...

Any suggestions on how to get that information from the ldb?


--
Diane
From: Jerry Whittle on 24 Feb 2010 10:37
Open the .ldb file with Notepad. You might be able to see who is in it. just
don't edit or change the .ldb file.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"DianePDavies" wrote:

> How can I easily see who is using the backend database?
>
> I can tell from the presence of a ldb-file that it is in use - but I dont
> know by who...
>
> Any suggestions on how to get that information from the ldb?
>
>
> --
> Diane
From: Ken Snell on 24 Feb 2010 21:23
Here's a function that I've written to do what you seek:

WhoIsInTheDatabaseLockFile
http://www.accessmvp.com/KDSnell/VBA_Functions.htm#WhoInDB


--

Ken Snell
http://www.accessmvp.com/KDSnell/


"DianePDavies" <DianePDavies(a)discussions.microsoft.com> wrote in message
news:734A1729-9A63-4482-8448-FFA791AD2931(a)microsoft.com...
> How can I easily see who is using the backend database?
>
> I can tell from the presence of a ldb-file that it is in use - but I dont
> know by who...
>
> Any suggestions on how to get that information from the ldb?
>
>
> --
> Diane


From: De Jager on 13 Mar 2010 12:59

"DianePDavies" <DianePDavies(a)discussions.microsoft.com> wrote in message
news:734A1729-9A63-4482-8448-FFA791AD2931(a)microsoft.com...
> How can I easily see who is using the backend database?
>
> I can tell from the presence of a ldb-file that it is in use - but I dont
> know by who...
>
> Any suggestions on how to get that information from the ldb?
>
>
> --
> Diane

 | 
Pages: 1
Prev: data base read-only
Next: Sharepoint 2007 lookup field showing up as memo in Access 2003