VB Code:
  1. Dim conn As ADODB.Connection
  2. conn = New ADODB.Connection()
  3. Dim objword As Word.Application
  4. 'I took out some unneeded stuff here
  5. sApppath = IO.path.Combine(Application.StartupPath, "Addressdb.mdb") 'you forgot a ( at the start here
  6.  
  7. conn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;Data source=" & sApppath & ";Mode=Share deny None" 'the database name is already in the sApppath varaible so no need for it at the end
  8. conn.Open()