+ Reply to Thread
Results 1 to 1 of 1

Access DB on shared folder (SharePoint/SkyDrive/DropBox)

  1. #1
    Registered User
    Join Date
    07-19-2013
    Location
    Atlanta, USA
    MS-Off Ver
    Excel 2013
    Posts
    1

    Access DB on shared folder (SharePoint/SkyDrive/DropBox)

    Happy New Year everyone!

    I am fairly new to the concept of file access using VBA. I am using an Access database (UsageData.mdb) defined as Target_DB in the code to record timestamp data every time a user clicks a button in my Excel workbook. I was able to define the path as shown below and access the db as long as the UsageData.mdb is local to my machine.

    db_Path = oWbk.Path & Application.PathSeparator & Target_DB

    Is there a way to move UsageData.mdb to a shared folder on SharePoint or DropBox or SkyDrive and still be able to access it? I tried using DropBox and defined the path as:

    db_Path = "https://www.dropbox.com/s/.../UsageData.mdb"

    However, I get an error saying "not a valid filename."

    Any advice on how i can tackle this?

    I have attached the code.

    Regards,
    Adi
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA code to Check if a Folder exists in SharePoint
    By shavazo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2013, 07:46 AM
  2. Help with Saving Excel to SharePoint Folder
    By Inez15 in forum Excel General
    Replies: 6
    Last Post: 03-08-2013, 06:59 PM
  3. loop through the sharepoint folder which needs domain authentication
    By sanc.jobs2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2013, 01:34 AM
  4. Checking Accesright for Sharepoint Folder using VBA
    By Fettertiger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2012, 07:45 PM
  5. Issues with many .xlsx files saved in a shared dropbox
    By vin.napoli in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 10-12-2012, 06:23 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1