[AccessD] AXP and Stored Procs

There is also the possibility that you are creating these new sprocs under a
different name than (dbo), in which case they sort weirdly and you see
"mySproc (afuller)" or something similar.

"Those who would sacrifice liberty for security deserve neither." 
-- Benjamin Franklin 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Chris Mackin
Sent: March 26, 2003 5:05 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AXP and Stored Procs


If you co to File->Connection, you don't even need to modify anything, Test
it and close it it will reset everything, alternatively shut down the .adp
and re-open.

If neither of those work you either need to check the permissions on the
connection (if you don't have permissions on it you won't see it) or make
sure you're connecting to the right database.

Chris Mackin
Denver Database Consulting, LLC
www.denverdb.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
jeffrey.demulling at usbank.com
Sent: Wednesday, March 26, 2003 2:50 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] AXP and Stored Procs



I have added some new Stored Procs to my SQL db.  However I cannot see them
in AXP (using ADP).  I can only see the ones that were orginally in the SQL
db when I first setup the ADP.

Anyone know how I can refresh the ADP so I can see the new Stored Procs?

TIA

-Jeff



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com