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
Bookmarks