Click here to Skip to main content
11,704,107 members (65,972 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# Access
I want to import some data to a datatable from an Access database table. When the file is stored locally, this works fine :-

string connString =
                "Provider=Microsoft.ACE.OLEDB.12.0;data source=C:\\database.accdb";

However, when the file is stored on Dropbox, this doesn't work :-

string connString =
                "Provider=Microsoft.ACE.OLEDB.12.0;data source=https://www.dropbox.com/sharedurl/BillingFileConverterV6.accdb";

and I get a "Not a valid file name" error.

Could someone let me know what I need to change?

Thanks in advance.
Posted 1-Jan-13 4:53am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Since DropBox requires Authentication, therefore it does not allows you to get data from that location.

Use your System Location where your dropbox saves files Locally as you have mentioned above.
  Permalink  
Comments
Member 9704153 at 1-Jan-13 13:27pm
   
Do even shared files on Dropbox require authentication??
Sheikh Muhammad Haris at 1-Jan-13 13:34pm
   
yes !

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Maciej Los 520
1 OriginalGriff 500
2 Sergey Alexandrovich Kryukov 381
3 Andy Lanng 294
4 F-ES Sitecore 220
0 OriginalGriff 8,784
1 Sergey Alexandrovich Kryukov 7,843
2 CPallini 5,107
3 Maciej Los 4,726
4 Mika Wendelius 3,606


Advertise | Privacy | Mobile
Web04 | 2.8.150819.1 | Last Updated 1 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100