Report Writer / Custom Table

You can use VBA with RetrieveGlobals.dll to create an ADO connection to SQL to get your data.

Let me know if you need more info. Note that the customer must have VBA or the Customisation Site License to use VBA.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

My only concern with RetrieveGlobals.dll is security. I know that in no longer brings out the sa in plain text... but it is my understanding that users passwords can be brought back in plain text. Our company policy (as most companies are) is not to allow anyone to know someone elses password. Further, a simple scipt could be placed on a pc that emails out the passwords as someone logs on. This could be a nightmare if a malicous employeed setup such a script.

RetrieveGlobals.dll does not return the plain text password. By default all passwords other than 'sa' are encrypted and so the password returned are still encrypted. And as mentioned 'sa' password is not returned at all. This does mean that the VBA will fail for 'sa', but is safer.

You can lock VBA projects to prevent anyone adding VBA scripts without authorisation.

I believe all of your security concerns can be addressed.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.