Hi all,
I have a few Pivot tables which are connected to some Access queries. I would like to know if the connectionstring is correct?
Environment:
Windows 7
Access 2010 - multi user database
Excel 2010 - multi user file
Here are an example of a connectionstring:
thanks
Anders
I have a few Pivot tables which are connected to some Access queries. I would like to know if the connectionstring is correct?
Environment:
Windows 7
Access 2010 - multi user database
Excel 2010 - multi user file
Here are an example of a connectionstring:
Code:
Provider=Microsoft.ACE.OLEDB.12.0;
User ID=Admin;
Data Source=C:\Users\MYNAME\test.accdb;
Mode=Read;
Extended Properties="";
Jet OLEDB:System database="";
Jet OLEDB:Registry Path="";
Jet OLEDB:Engine Type=6;
Jet OLEDB:Database Locking Mode=1;
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
thanks
Anders