Re: prompt for parameter in a view

Hi,

SQL Server will not prompt for a user input. Access will allow because it
have both Front end and back end.

Thanks
Hari
SQL Server MVP

"Tyler" <Tyler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CA2CA968-4B15-4ED6-AECF-FE3C17C119AB@xxxxxxxxxxxxxxxx
>I would like to create a view that will prompt the user for a parameter.
> Much the same way a user can provide the paramenter for a query in Access.
> Seems like it should be simple, but I don't know how to do it.
>
> Any ideas?
>
> Thanks
> --
> Tyler


.

Relevant Pages

  • Re: Linked Table Password
    ... Prompt When Opening Linked Table" - ... recreating the links to the SQL Server ... > relationships again after the automated process. ... These connections can be DSN or DSN-less connections, ...
    (microsoft.public.access.security)
  • Re: Security bug?
    ... SQL Server 2000 Setup has been prompting for a password for sa since RTM, ... This is nothing new with SP3. ... it's only a prompt and the ...
    (microsoft.public.sqlserver.security)
  • Re: Problems using ADODB and adPromptNever
    ... on startup that it is correctly linked to SQL Server. ... prompt to the value for adPromptNever. ... I suspect the OLEDB provider does not support this property, ...
    (microsoft.public.data.ado)
  • Re: Problems using ADODB and adPromptNever
    ... on startup that it is correctly linked to SQL Server. ... prompt to the value for adPromptNever. ... That's an ODBC thing. ... a custom form. ...
    (microsoft.public.data.ado)
  • Problems using ADODB and adPromptNever
    ... on startup that it is correctly linked to SQL Server. ... Set db = wksp.OpenDatabase("", dbDriverNoPrompt, True, strTemp) ... prompt to the value for adPromptNever. ...
    (microsoft.public.data.ado)