Accpac User Name

[iwells]

Hi,

Is there no way to access the Username field associated with a user ID in SQL? I don't see this field in any table and every macro I see calls view AS0003, but how can this data be accessible through a macro, but not SQL.

Doesn't make sense to be able to access all the other information in the system, but not have a username accessible.

 

[Jay Converse]

No. Use AUDTUSER if you have to.

 

[ettienne]

Users are not stored in an SQL table, they are stored in USERS.ISM in the Site folder.
What are you trying to achieve?

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[Jay Converse]

Oh, wait, the actual name? No, you can't unless you make your own Optional Field and populate it manually.

 

[ettienne]

If I want to pull the user name into a report I import the users into an optional field and use that into the report.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[iwells]

We have an audit macro here that extracts information and we're trying to reduce our dependency on macros and convert things to SQL scripts since we have more resources with that knowledge. Everything in this audit macro can be performed using SQL scripts except the username field.

I was a former VBA programmer so I can use the API and macros if needed, but currently we have items that are highly dependent on a single user who's no longer in the department and rather than have items dependent on me, moving forward I'd like to try and convert them to something that even people outside of our department could understand if necessary.

 

[ettienne]

In this case you are stuck with VBA, unless you want to call the API directly and read the USERS.ISM file - but that is more complex in my opinion.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net