Thank you for the quick response im still struggling though
this is the connection
Dim Session As New AccpacCOMAPI.AccpacSession
Dim DBLink As AccpacCOMAPI.AccpacDBLink
Session.Init("", "AS", "AS1000", "55A")
Session.Open("ADMIN", "ADMIN", "TSTDAT", Date.Today, 0, "")...