Many people are asking if it is possible to connect to remote MS Access database. Well, I can say it is possible but a bit tricky - you must have IIS running on the server, plus some configs for ado library on the server are also in order.
Here is the general idea on coding:
VB Code:
  1. Option Explicit
  2.  
  3. Dim adoConn As ADODB.Connection
  4. Dim adoRst As ADODB.Recordset
  5.  
  6. Private Sub Command1_Click()
  7. '============================
  8. Dim strConString As String
  9. Dim strSQL As String
  10.  
  11.     'assign connection string
  12.     strConString = "Provider=MS Remote;" & _
  13.                    "Remote Server=http://192.168.1.1;" & _
  14.                    "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
  15.                    "Data Source=MyRemoteDB;Persist Security Info=False"
  16.    
  17.     'initialize connection object variable
  18.     Set adoConn = New ADODB.Connection
  19.     'open connection
  20.     adoConn.Open strConString, "admin", ""
  21.    
  22.     strSQL = "Select * from Orders"
  23.    
  24.     'initialize recordset object variable
  25.     Set adoRst = New ADODB.Recordset
  26.     With adoRst
  27.         .Open strSQL, adoConn, , , adCmdText
  28.         If Not .EOF Then
  29.             Do While Not .EOF
  30.                 'read each record here
  31.                 '...
  32.                 .MoveNext
  33.             Loop
  34.             .Close
  35.         End If
  36.     End With
  37.    
  38.     'destroy recordset object if necessary (or do it when you unload the form)
  39.     'Set adoRst = Nothing
  40.    
  41.     'destroy connection object if necessary (or do it when you unload the form)
  42.     'Set adoConn = Nothing
  43.  
  44. End Sub
For information on how to cofigure IIS refer to the following MSDN article:
http://support.microsoft.com/kb/q253580/

I hope this sample is going to be usefull.