Andy,

I enjoyed the article and I await the follow ups to it.  I have recently changed gears in my career.  Now my IT role is devoted to my part time...

docmd.runsql "Drop Table tableName"

Edwin,

I thought you were looking for Distinct values of a "C0c25".  I did not understand that you were just wanting to see all DISCTINCT values...  Sorry I offended.

God Speed..

Did you check to see if the Report Service is running.  If it is not I would check who the service is running as and make sure they have the...

The only thing y ou would have to do with this though is do a WHERE CLAUSE because in the real world you you may have a value of Q...

You Can use the PERMISSIONS function as well. I can't remember if you need to loop through the logins.

runelords,

You can add records in the Tables Node of Enterprose Manager.  This is assuming that when you registered the Servers on the PC that is running Enterprise Manager you used...

It depends on what is being returned from the select statement.  If you are only expecting one row back you could use:

------------------------------------------------------------------

CREATE PROC NAME_YOU_LIKE

Parameters Parm_type

as

DECLARE @ret parm_type

SELECT @ret=Name_of_Colum FROM tableTOSelect WHERE...

You could build a component that you create in VB and register it on the computer.  In that component try to open the connection with the user name and password. ...