Results 1 to 3 of 3
  1. #1
    sanprasa is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2018
    Posts
    3

    Scripting.FileSystemObject

    Dear Friends




    I am having issue regarding attaching files in Sharepoint online from other computers. We are using the database from our local machines.


    I am able to upload files in share point online however when my colleagues try to upload getting error "76, Path not found".


    I already added Microsoft Scripting Runtime from library in my code and even my colleagues have added all those libraries.


    error in this line
    -------------------


    FSO.CopyFile Source:=LocalAddress, Destination:=savepath & attName & "." & FileExt

    Thanks,
    Sanjay

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    What are you setting savepath to?

    My understanding is that a SharePoint style URL won't work from the file scripting object.
    You need a UNC path (which is slightly different) or a mapped drive location.

    Edit - more info here: https://www.utteraccess.com/forum/in...wtopic=2029080
    Last edited by Minty; 08-06-2020 at 09:26 AM. Reason: Further Info
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    sanprasa is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2018
    Posts
    3
    My savepath is

    savepath = "\\uxxxxxxxxns.sharepoint.com\sites\HRM-MRPODatabase\MRPDB_Attachments"

    Source = Me.AttachMemo.Value

Please reply to this thread with any new information or opinions.

Similar Threads

  1. need Scripting help
    By pfales in forum Programming
    Replies: 3
    Last Post: 05-29-2013, 12:39 PM
  2. VBA Scripting
    By M155_Access in forum Programming
    Replies: 9
    Last Post: 05-24-2013, 12:09 PM
  3. Replies: 1
    Last Post: 09-20-2012, 03:37 PM
  4. VBA Scripting
    By data808 in forum Access
    Replies: 1
    Last Post: 08-26-2012, 11:29 PM
  5. Connect via ODBC and vb scripting or php
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-28-2010, 08:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums