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

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
 
B

Brian M. Sockey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.mdb or .adp which is best to use with SQL 2K 10
Repost - Recordsource For Reports 4
How to use a combo box variable in a VBA module 1
Code to import spreadsheets 1
connection string for connecting to another Access DB? 3
"Do you want FP to create a db connection for this db" ?? 4
want to be able to search for attachments and delete them is they 1
VB script for connection to DB 1

Top