artful at rogers.com
artful at rogers.com
Sun Dec 10 19:52:03 CST 2006
I think that this all depends on how you are linking to the DB. If you are using an ADP then it's trivial, just place the name of the sproc in the rowsource attribute and that's that. If you need to pass a parameter or more than one, set them up with static functions (or as JWC would say, as members of a class) then load and go. A. ----- Original Message ---- From: Lonnie Johnson <prodevmg at yahoo.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Tuesday, December 5, 2006 9:41:52 AM Subject: Re: [AccessD] ADO Stored Procedure Call I know this sounds simple but could you call your stored proc via a passthough query in your code? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: Robert L. Stewart <rl_stewart at highstream.net> To: accessd at databaseadvisors.com Sent: Tuesday, December 5, 2006 8:27:37 AM Subject: [AccessD] ADO Stored Procedure Call I need to call a stored procedure via ADO in Access and have control go back to Access immediately instead of it waiting on the stored procedure to execute. Does anyone know how to accomplish this? Robert -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ____________________________________________________________________________________ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com