get users account name

J

JNS

I have added this code snippet to my database to get currently logged on
users account name. I get an error message "Activex component can't create
object". i have renamed acwzmain.mde , acwztool.mde, and acwzlib.mde and run
the repair utility but still get same error message. Here is the code:

Dim objNet As Object
Dim strUserName As String
Dim strUserDomain As String
Dim strComputerName As String

Set objNet = CreateObject("WScipt.Network")
strUserName = objNet.UserName
strUserDomain = objNet.UserDomain
strComputerName = objNet.ComputerName
Set objNet = Nothing
 
R

Rick Brandt

JNS said:
I have added this code snippet to my database to get currently logged
on users account name. I get an error message "Activex component
can't create object". i have renamed acwzmain.mde , acwztool.mde, and
acwzlib.mde and run the repair utility but still get same error
message. Here is the code:

Dim objNet As Object
Dim strUserName As String
Dim strUserDomain As String
Dim strComputerName As String

Set objNet = CreateObject("WScipt.Network")
strUserName = objNet.UserName
strUserDomain = objNet.UserDomain
strComputerName = objNet.ComputerName
Set objNet = Nothing
Click to expand...

Should that be CreateObject("WScript.Network")?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User network login 1
get network login name 14
Get Current User Name 1
list groups user error 4
Help with User Tracking 1
Permissions on table object 1
Complile Error - Only certain users 3
Retrieving and setting user logon name in a form 2

Top