ник: alecks_lp
Re: SQL + Access Посмотрите в хелпах синтакс и параметры Open Method (ADO Connection)
Например:
Dim Cnn As ADODB.Connection
Set Cnn = New ADODB.Connection
Cnn.ConnectionString = "driver={SQL Server};server=MySqlServer;" & _
"user id=MyUserID;password=MyPassword;"