Results 1 to 8 of 8
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095

    Can VBA copy file use a cloud service as target


    I'd like to copy a file to a cloud service, like Google Drive or OneDrive. Can that be done?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,552
    Don't see why not. My Google drive is even assigned a drive letter, which can be changed?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    I looked for a way to "map to network" drive for both Dropbox and OneDrive, but I don't see anything. How did you map a drive to Google Drive?

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,552
    It does it itself. However you can reassign another if need be.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    YES! I see it now! I wasn't signed in to Google, which is somewhat strange in itself. Anyway, thanks, I'll now do some experimenting. (Too bad Dropbox only offers a minimum of 2TB of storage over an above the free 2GB. Obviously, they're not targeting home users)

  7. #7
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,157
    OneDrive and SharePoint locations are a bit of a nightmare if someone hasn't logged in as you can't easily test the connection to them at that point.
    Also you can't use any of the normal IsFileOpen type functions if it isn't mapped.

    Some of this would be easily resolved if they M$ pulled their finger out and added the new browser combability they have pushed back (again).
    On a windows 11 machine you can't force a connection to open on SharePoint through I.E.11 as it doesn't have it installed. (Which is the only way of using UNC paths, which is obviously preferred)
    Last edited by Minty; 02-09-2022 at 02:41 AM.
    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 ↓↓

  8. #8
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    Thanks Minty. So far, Acronis can write its tib files directly to Dropbox and OneDrive, but hangs waiting for Google Drive to become free. Not sure what the latter issue is yet?

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

Similar Threads

  1. Replies: 3
    Last Post: 11-16-2017, 11:26 AM
  2. Replies: 0
    Last Post: 02-13-2017, 04:45 PM
  3. Saving Acess file to One Cloud
    By Lesky in forum Access
    Replies: 2
    Last Post: 12-07-2014, 09:24 PM
  4. Splitting a database with a cloud service
    By LadyLyke in forum Database Design
    Replies: 2
    Last Post: 03-20-2013, 02:43 PM
  5. Open,new and save as an excel target file
    By dacodac in forum Programming
    Replies: 7
    Last Post: 01-31-2013, 05:25 AM

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