Solved

Get machine ID of Access user

Posted on 2013-05-17
1
752 Views
Last Modified: 2013-05-17
I need to capture the machine ID of the user. How do I go about doing that in VBA?
The problem is that I can get the user ID now, but we need to log where the user is accessing an application and entering data into it. This is for quality assurance tracking purposes in a production system.

An example: Only new parts should go into a new product, so if the user is entering data in a system that only is used in a warehouse that has used parts then something might be wrong...
0
Comment
Question by:EvertJor
1 Comment
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 39176520
Two ways:

1 (preferred)

http://access.mvps.org/access/api/api0009.htm

2)
Dim x
x = Environ("ComputerName")
Returns the DeviceID
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now