adp connection to sqlserver - simple for you, hard for me

  • Thread starter Thread starter cubic_mile
  • Start date Start date
C

cubic_mile

hi guys, i used to be an access programmer, but havent used access in quite
a while.
i just upsized an access03 mdb to sqlserver adp.

i dont have a clue, how to open the connection to the sqlserver, for
instanct to read the contents of a recordset.

pseudocode would be:

mydb = currentdb //the sqlserver db
myrs = mydb.openrecordset

well, sy out there to help me??

thanks, cubic
 
You'll need to move from DAO to ADO. If your ADP is already connected to a
SQL Server, then you would just need code similar to the following;

Dim RS As New ADODB.Recordset
RS.Open "SQL Statement", CurrentProject.Connection

Brian M. Sockey
www.televantagenorthwest.com
 
Back
Top