getting the MAC address

[ac]

Dear all,

I would like make my access program BE stores the MAC address of the front
end stations so that only the regonise MAC address
can be used?

how can i do it? how can i protect the MAC table at the back end so that no
one can change it or see it?

thank you.

ac.

 

[JohnFol]

Use the following KB to get the MAC address
http://support.microsoft.com/default.aspx?scid=kb;en-us;175472

To protect it, just use Access' built in security model, or encrypt it, or
bury the value in the registry or a combination of all . ..

 

[JohnFol]

You can also do this using WMI, but not sure what the lib to use in Access
is. Here's a .Net bit of code to do it.

Dim mc As System.Management.ManagementClass

Dim mo As ManagementObject

mc = New ManagementClass("Win32_NetworkAdapterConfiguration")

Dim moc As ManagementObjectCollection = mc.GetInstances()

For Each mo In moc

If mo.Item("IPEnabled") = True Then

MsgBox("MAC address " & mo.Item("MacAddress").ToString())

End If

Next

 

[ac]

Thanks alot! your first first solution is easier for me, will try that.
cheers
ac.