Hi Pros again,

I had been searching the net for two days and i couldnt find any clue on how to upload and download files from MS access to sharepoint.(bidirectional)

Now let me explain, my idea is that when i click on a upload button the window filedialog would came up and let us choose the file we wanted to upload it into sharepoint. so once we click on the file, it will automatically uploaded to a specify sharepoint path. and then when i click on a download button, it would download the same file that i have uploaded perviously in sharepoint.

so for now, I have create an access form(which i found the source code form the net) that have the file path which going to upload into sharepoint but then when i click on the button its only navigate the path and would not upload the file up(which I think the source i got it form the net only does the path and not uploading). I try to search the net again and i couldn't find any help so i came back here to seek for advise and help again.

Well, right now I'm totally clueless on how to upload the path file to sharepoint with the access form so that when I click on the download button, it will actually link back to the path i saved perviously and download.

anyone did a similar things as me before, do you mind sharing the code ?? or have any better way of doing it ? please advise..

how to improvise my code works?
Dim fdg As FileDialog, vrtSelectedItem As Variant
  Dim strSelectedFile As String
 
  Set fdg = Application.FileDialog(msoFileDialogFilePicker)
 
  With fdg
    .AllowMultiSelect = False
    .InitialView = msoFileDialogViewDetails
     If .Show = -1 Then
        For Each vrtSelectedItem In .SelectedItems    'onby be 1
          strSelectedFile = vrtSelectedItem
        Next vrtSelectedItem
        Me![txtPicturepath] = strSelectedFile
      Else     'The user pressed Cancel.
      End If
  End With
 
  Set fd = Nothing