Does anyone have any VBA code to determine WHO has the file open?
Advanced Beginner
Windows 10 
Access 2010 64bit
Does anyone have any VBA code to determine WHO has the file open?
Very Inert Person
Windows 10 Access 2016
I relied on logging in/out users via table records. If you drag the laccdb file into notepad (may result in gibberish) or Notepad++ and find that users are logged in as admin, that file won't help you much. Easy enough to get users via recordset or query when in a table. You might want to employ a log out routine if they leave the db idle for long periods of time.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 10 Access 2010 32bit
laccdb file shows computer name. If you need to know a user name then maintain a login process. Review https://www.access-programmers.co.uk...2#post-1779515
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Very Inert Person
Windows 10 Access 2016
and it usually shows user as "admin"?laccdb file shows computer name
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows Vista Access 2010 32bit
Theres an app that tells you Whos In the Db.
attached.
Advanced Beginner
Windows 10 Access 2010 64bit
Sorry, I should have been more specific. Its determining who has an excel file open using Name Filepath As
VIP
Windows 10 Access 2010 32bit
What the heck is "Name Filepath As"?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Very Inert Person
Windows 10 Access 2016
Name is a vba statement. I suspect that you have seen it before?
So " Name variable As SomePath" ?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 10 Access 2010 32bit
Nope, not familiar with it. Guess I will learn something new.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Very Inert Person
Windows 10 Access 2016
I was on my phone when I wrote that, so please excuse my brevity. For some reason I thought there was a long ago post about it where you were involved. Try?
https://docs.microsoft.com/en-us/off...name-statement
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 10 Access 2010 32bit
Okay, that does tickle some vague recollection. Must have been quite a while ago. Also, the context it was mentioned in didn't help. Don't see how it relates to issue of determining who has an Excel file open.
Dave, why do you think it is related?
How would you think program on one computer could know what files another computer has open?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Very Inert Person
Windows 10 Access 2016
This should have been in an Excel thread?
Most of the code you'll find for knowing who has a file open is Excel based. That's probably because you can't share an Excel file, which is not an issue with Access. I'd say this could be solved by grabbing code posted by others in response to this issue. It's out there.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Workbooks.Open won't open Excel file in Edit Mode
Posting Permissions
Reply With Quote