Re: Display ADO recordset

BillyRogers wrote:
One thing I forgot to mention is that there are parameters that need
to be passed to the stored procedures based on account numbers
entered into text boxes on the form.

How do I pass the parameters to the stored procedure in the
passthrough query?

I just change the SQL each time...

CurrentDB.QueryDefs("QueryName").sql = "EXEC..."

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Convert SQL Account to Windows Accounts + EXEC on ALL SPs
    ... I have an SQL Server 2000 Database that has an "SQL Account" that has ... execute permission on all Stored procedures. ... This one account is used by "all workstations". ... I want to fix this and use Windows Accounts, and get rid of that SQL ...
    (comp.databases.ms-sqlserver)
  • Newbie: Restrict user account access to stored procedures
    ... to add/edit/delete tables and stored procedures, and a dedicated user ... account for my website. ... I am manipulating all the data through stored procedures and would like to ... Is it possible to restrict a user account to the stored procedures only? ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Procs in SQL 2005
    ... How do i give execute privileges on stored procedures to an account? ... Arne Garvander ... Professional Data Dude ...
    (microsoft.public.sqlserver.security)
  • Re: change ownership of objects
    ... Fiirst of all change the password for his account to a one with special ... user to DBO. ... I am afraid to delete his account in fear all the stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: Cascading Combo problem.
    ... I stumbled on to a poorly documented method for using a cascading combo ... boxes in Access. ... If you define your row sources as Stored Procedures, ...
    (microsoft.public.access.formscoding)