So I used pivot table in excel, where its source is a table on access. So, the Access file is in a server. The Excel file is in Dropbox. When I open the Excel in the dropbox, in another computer, when I refreshed it, it told me: "Could not find installable ISAM.". But when I opened the exact copy of the Excel file that located in the same server (and folder) as the Access file, it worked (could be refreshed). And it's done on the same computer.
The Connection String:
Provider=Microsoft.ACE.OLEDB.12.0;
User ID=Admin;
Data Source=\\19x.yyy.1.100\database\Dummy\Dummy.accdb;
Mode=Share Deny Write;
Extended Properties="";
Jet OLEDB:System database="";
Jet OLEDB:Registry Path="";
Jet OLEDB:Engine Type=6;
Jet OLEDB:Database Locking Mode=0;
Jet OLEDB:Global Partial Bulk Ops=2;
Jet OLEDB:Global Bulk Transactions=1;
Jet OLEDB:New Database Password="";
Jet OLEDB:Create System Database=False;
Jet OLEDB:Encrypt Database=False;
Jet OLEDB:Don't Copy Locale on Compact=False;
Jet OLEDB:Compact Without Replica Repair=False;
Jet OLEDB:SFP=False;
Jet OLEDB:Support Complex Data=False;
Jet OLEDB:Bypass UserInfo Validation=False;
Jet OLEDB:Limited DB Caching=False;
Jet OLEDB:Bypass ChoiceField Validation=False
There must be the a million post/thread about this, but when I tried to read it, since I don't even undertand how the connection worked, I didn't understand what people talking about. When I was importing the table, I just opened 'DATA' tab, then choosed 'From Access', and from then just 'Yes', 'yes', 'yes' (and, surely, choosed which from which file and table to be imported).
So, what's the cause and how to fix it?
Bookmarks