Macro to Read user login information

[Boris10]

Dear all,
I am trying to create a macro that reads or picks up the users name as he logs into ACCPAC. I am wondering if anyone has any ideas. Alternatively, i am looking for a way to create a login screen, that will require ACCPAC username and password - how can the password be verified against the one stored in the database.

Any help would be highly appreciated.

P.S

I am using ACCPAC 6.0A and SQL DB

 

[trmeupey]

Hi Boris,
Passwords are not stored in the SQL DB in Accpac
Regards,

 

[Boris10]

Hi,

Thank you for the reply. Any ideas how i can get user's name once he opens my Macro. That's why i was thinking to have something like a second level login where i could verify that the user is who he says he is.

Regards

Boris

 

[Jay Converse]

Session.UserID gives you his ID, then you .Browse the AS0003 view to get names.

But why do you care "who he says he is"? If he logged in with somebody else password, then it doesn't matter. If you want better security, use Windows Authentication.

 

[Boris10]

Thank you,

I am developing, a custom workflow. So i need to get userIDs as they open my macro, so as to know, what authorisation levels they possess, requisitions that they have raised and so on and so forth. There is some functionality missing in PW module so i want to add that functionality by creating a macro
.

 

[Jay Converse]

Then use Session.Userid, then .Browse AS0002 for authorizations.

 

[Boris10]

Thank you,

Session.UserID is returning null values. Though i tried out the following code from the forum and its working,

Session.Init "", "IC", "IC0310", "60A"
UserID = Signon.Signon(Session)
txtUserId.Text = Session.UserID

.
Thank you for your help.

 

[Jay Converse]

The user hasn't logged in yet.