Information fro .ldb file

[noaccessguru]

Hi guys,I have a quick question, this is probably way out of my area but just thought someone might know. (and I apologise if I havent posted this in the right section of the Forum)In the .ldb file if you open that in Notepad, at my work it gives me the ‘Computer Name’ of who is using the database. (eg ABC1234 – Admin)Is there a way to change this to show me the ‘Username’ or is this a Business IT thing that pulls from our IP address and isn’t related to Access?I dont want to set up Users and Groups etc, I just use this as a guide of who I need to kick out if I do.Hope someone can shed some light on this for me!Thanks in advance.(Apologies if this posts without paragraphs etc I dont know whats going on!!)

[ssanfu]

Maybe this code will help:
http://support.microsoft.com/kb/186304

[June7]

Is your db a split design with each user running their own copy of frontend from their own computer? If they are then that code might not work as each copy will open its own ldb file. I will have to do some testing of this code with the ldb of the backend.

What I do with a split db is have a table of users. This table has fields for the username, initials, computer name. The computer name field is populated by code when user opens frontend and then set to null when they exit. If I thought any user would log into more than one computer at a time and open the db on both machines, I would do things a little different, but doubt that will ever happen (except by me). I grab the username from the network with: VBA.Environ("USERNAME") - yes, type it exactly like that. Access won't recognize the Environ function but VBA does.

[noaccessguru]

Thanks ssanfuHi June7Thanks for that……Im not great with code etc, but what you have suggested sounds like what I want. Obviously I don’t have a list of everyone’s computer names so I need to know who the Username is associated to it.Yeah my database is a split design with everyone using their own copy of the mde file from their computer. So I can tell when someone is using it as I can see the BE.ldb database in my Network folder….Since I am still just learning so only really know how to do the basics (DoCmd etc) at the moment, but will attempt what you suggested, and will have a play around this and see what happens!So I guess I might be back with some more questions !Thanks again....

[June7]

I don't have a list of computer names. A user can log into the network from any machine, although they usually use the one at their desk. I forgot to mention that I also grab the computer name from the network that the user is logged in at. The table has the username and their initials because we save initials into records of db. Code grabs username from network, finds them in the table, populates the computer name field and grabs their initials and populates a textbox on main menu form which always stays open.

Review this about Environ function http://blogs.officezealot.com/charle...2/10/3574.aspx