Thanks, I was thinking I would need to use the SDK and VBA.  I need Access to update the template. Just not sure how to get it going.   

The VBA compiler/engine is basically VB6 so you will need to use the LFSO COM DLL instead of the RA .Net DLL.

Here are LogIn and LogOut methods for VBA

Private Sub LogIn(ByRef LFDB As LFSO103Lib.LFDatabase, ByVal LFServerName As String, ByVal LFRepositoryName As String, ByVal LFUserName As String, ByVal LFPassword As String)
  Dim app As LFSO103Lib.LFApplication
  Dim serv As LFSO103Lib.LFServer
  Dim conn As LFSO103Lib.LFConnection
  If LFDB Is Nothing Then
    On Error GoTo ErrHandler:
    ' Creates a new application object.
    Set app = New LFSO103Lib.LFApplication
    ' Finds the appropriate server.
    Set serv = app.GetServerByName(LFServerName)
    ' Gets the repository from the server.
    Set LFDB = serv.GetDatabaseByName(LFRepositoryName)
    ' Creates a new LFConnection object.
    Set conn = New LFSO103Lib.LFConnection
    ' Sets the user name and password.
    conn.UserName = sLFUserName
    conn.Password = sLFPassword
    ' Connects to repository.
    conn.Create LFDB
  End If
  Exit Sub
ErrHandler:
  MsgBox Err.Number & vbCrLf & "Failed to Log in", vbCritical + vbOKOnly, "Error"
  Set LFDB = Nothing
End Sub

Private Sub LogOut(ByRef LFDB As LFSO103Lib.LFDatabase)
  Dim conn As LFSO103Lib.LFConnection
  If Not LFDB Is Nothing Then
    On Error GoTo ErrHandler:
    ' Get LF Connection object
    Set conn = LFDB.CurrentConnection
    ' Log Out / Close connection
    conn.Terminate
    Set conn = Nothing
  End If
ErrHandler:
  Set LFDB = Nothing
End Sub

Then to Log in, you would do:

Private Sub btnProcess_Click()
  Dim sLFServerName As String
  Dim sLFRepositoryName As String
  Dim sLFUserName As String
  Dim sLFPassword As String
  Dim db As LFSO103Lib.LFDatabase
  ' To use Windows Authentication
  ' Make the sLFUserName and sLFPassword = ""
  ' Edit the next 4 lines to set up login info
  sLFServerName = "YourLFServerName"
  sLFRepositoryName = "YourRepositoryName"
  sLFUserName = "YourUserName" ' For Windows Authentication = ""
  sLFPassword = "YourPassword" ' For Windows Authentication = ""
  ' Start the LF Update
  Set db = Nothing
  ' Log into the repository
  LogIn db, sLFServerName, sLFRepositoryName, sLFUserName, sLFPassword
  ' Only process if the Login was successfull
  If Not db Is Nothing Then
    On Error GoTo ErrHandler:
    'Do your work here

    'Done with work
lblReturn:
    ' Log Out of Repository
    LogOut db
  End If
  Exit Sub
ErrHandler:
  ' Inform user of error
  MsgBox Err.Number & vbCrLf & Err.Description, vbCritical + vbOKOnly, "Error"
  ' Return to log out of repository
  GoTo lblReturn:
End Sub