how to connect the access to the sql

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 /
 
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
 
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
 
Someone else here will have to help with the code. I go via the ODBC route
and/or use the *.adp option.

Ed Warren.
 
Back
Top