Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#53584 - 05/31/18 07:34 AM User table or view
Alfagomma
Member


Registered: 11/24/05
Posts: 4
Loc: Montreal
Hi,
I would like to download the user info (I'm after the user email 1 address) into Excel through an ODBC Query. I can't find the table or view that contains this info.

Can anyone help?

Thanks

Dino

Top
#53585 - 05/31/18 07:39 AM Re: User table or view [Re: Alfagomma]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7629
Loc: Location, Location
You can't. There is no table, it's in a special file.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53586 - 05/31/18 09:56 AM Re: User table or view [Re: Jay Converse]
Alfagomma
Member


Registered: 11/24/05
Posts: 4
Loc: Montreal
Oh, I see.
Thanks Jay

Dino

Top
#53587 - 05/31/18 09:59 AM Re: User table or view [Re: Alfagomma]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7629
Loc: Location, Location
You _can_ export to a file from the User screen, but you can't use ODBC.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53588 - 05/31/18 11:11 AM Re: User table or view [Re: Jay Converse]
Alfagomma
Member


Registered: 11/24/05
Posts: 4
Loc: Montreal
Jay,
Yes I am aware of that, thanks. I am also able to access RotoID AS0003 from VBA, although I am writing a report with Sage Intelligence, and that uses exclusively ODBC (I believe).
I didn't think it was possible, but I asked the question to be sure.
Your feedback is very appreciated.
Dino

Top
#53619 - 06/08/18 09:05 AM Re: User table or view [Re: Alfagomma]
Alfagomma
Member


Registered: 11/24/05
Posts: 4
Loc: Montreal
To anyone interested in this topic:

Sage Intelligence does actually allow you to run macros or add-ins after a report has completed execution. So, the problem outlined above is solved with a piece of VBA code that reads the AS0003 view.

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: