I'm not a newby in programing/code but in Access-SqlServer i am.
I have all my code (and works fine) in DAO but with a connection to a mdb db.
Now i've already passed to sqlserver and need to put my code to DAO. Problems!!

I can't establish a connection into my db.
I have:
1. A DSN called DSNName;
2. A front-end app (.mde) with all my table connection;
3. My DB SQL is named SQLDataB;
4. My username and password are the same : ccdruser.

I need to create a connection ADODB, a recordset to update some records.

I have several problems reading the sintaxe.