How to get the MAC address of the machine using the Access with VBA?

[Ricardo de Mila]

Was wondering to know if could somebody tell me how to get the mac address of the computer that has started up the msAccess.

Also, If I'm using the msAccess in a central virtual machine using Windows server 2003, I'd like to have the mac address of the physical machine that is using the msAccess instead of the machine that is serving the Access.
Not sure if was clear enough.
Thank you.

[ADezii]

Just subscribing for now...

[ADezii]

Download the Attachment and see if this is what you are looking for. I reduced the Code to its simplest State, while maintaining complete functionality.

[Oralloy]

ADezii,

Which attachment?

I'm certain I'm being blind, but I just don't see it.

[ADezii]

Not sure what is going on because I can see and Download the Attachment, but try this:

[Oralloy]

Now I see them both.

Thanks

[Ricardo de Mila]

Thank you everybody. I have tested and it worked ok so far. I'll have to study it a little bit to understand some concepts and also will check if does it work also with WINDOWS SERVER 2003.
Thank you again.

[ADezii]

You are quite welcome.