[MS_AccessPros] Re: Pass through queries

 

Very helpful, thanks Patrick.
Sam

--- In MS_Access_Professionals@yahoogroups.com, "patrickawood" <pwood57@...> wrote:
>
> Hi Sam,
>
> You can use an unnamed and unsaved temporary Passthrough Querydef which is a method recomended by Microsoft. When your procedure ends the unnamed QueryDef is destroyed.
>
> You can use a simeple custom function that produces the connection string for the QueryDef. If you use a mde or accde file or lock your code Project your user is unlikely to even know your Procedure exists.
>
> You may find an article I wrote helpful. It applies to SQL Server as well as SQL Azure and it uses Passthrough action queries. Although it is about creating logins it works the same as Passthrough queries. It is entitled "How to Use Microsoft Access to Create Logins in a SQL Azure Database"
> http://gainingaccess.net/Articles/HowToCreateSQLAzureLogins.aspx
>
> Kind Regards,
> Patrick Wood
> Microsoft Access MVP
> Gaining Access Technologies Founder
> http://gainingaccess.net
> Microsoft Access and SQL Azure Information Center for Developers:
> http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
>
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 5
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___