how to connect the access to the sql

[Guest]

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 /

 

[Ed Warren]

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

 

[Guest]

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]

Someone else here will have to help with the code. I go via the ODBC route
and/or use the *.adp option.

Ed Warren.

 

[Guest]

thank you

Someone else here will have to help with the code. I go via the ODBC route
and/or use the *.adp option.

Ed Warren.