I am trying to use MS Access front end to my SQL database over VPN but
I am having trouble creating a DSN (used by Access to reach the linked
tables). Any help is greatly appreciated.

Use the ODBC tool in "Administrative Tools" on your server to create a DSN
(Data Source Name). Name that DSN with a single word like "BusinessData".
Then you can connect with something like:

Dim cnnConnection As ADODB.Connection
Dim comCommand As ADODB.Command
Dim rstNumber As ADODB.Recordset
Dim strConnect As String

strConnect = "Provider=SQLOLEDB;Data Source=ServerName;" & _
"Initial Catalog=BusinessData;" & _
"User ID=Arvin;password=ItsASecret"

Set cnnConnection = New ADODB.Connection

cnnConnection.Open strConnect


"BigBird" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am trying to use MS Access front end to my SQL database over VPN but
> I am having trouble creating a DSN (used by Access to reach the linked
> tables). Any help is greatly appreciated.
>