Re: how to connect the access to the sql
- From: "Ed Warren" <eowarren@xxxxxxxxxxxxxxx>
- Date: Tue, 29 Nov 2005 20:57:52 -0600
Someone else here will have to help with the code. I go via the ODBC route
and/or use the *.adp option.
Ed Warren.
"benson" <benson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F22D9EF0-DE33-45B7-BE60-6890DD4E2811@xxxxxxxxxxxxxxxx
>i know vba code but , i can write the code :
> set rs = new adodbo.recordset
> temp = "select * from table where ^"
> rs.open temp ,currentprojection.connection ,*,*
> i know the currentprojection,connection
> but i don't how to write the code to build the link that access to sql
> can you give me a exampe
> thanks for advence
>
> "Ed Warren" wrote:
>
>> To link in Access (mde, mdb) to SQL you can use an ODBC connection
>> (control
>> panel, odbc, add a connection to your sql server, then use that
>> connection
>> as a link in Access)
>>
>> and/or
>> use VBA code to build a link
>>
>>
>> To link a *.adp file you use ADO connections.
>>
>> Ed Warren
>>
>> "benson" <benson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:B3F64B8E-7185-49CB-A690-EC91F573A85B@xxxxxxxxxxxxxxxx
>> > wo know access can connect to the sql serve made by microsoft , but i
>> > can
>> > not get the success ..the access .adp can connect the sql ,but i know
>> > sql
>> > server little , your help i s great and thank you for advance /
>>
>>
>>
.
- References:
- Re: how to connect the access to the sql
- From: Ed Warren
- Re: how to connect the access to the sql
- Prev by Date: Re: Updating a calculated value
- Next by Date: Re: DCount Problem
- Previous by thread: Re: how to connect the access to the sql
- Next by thread: Searching For Rules Depending On Field
- Index(es):
Relevant Pages
|
