B
Becky
Exceo2007 Pivot tables have multiple internal settings -- see list below.
Where do they all get set? What are all the different variables. What do
they impact? Some of them are obvious, but a few are not. I have a couple
books -- but none go into that detail. With converting to Office2007, we
have pivot tables that were "convereted from Excel2003", some built from
scratch in Excel2007, and some created through MSQuery, many edited from old
Excel2003 worksheets. With multiple users, the possibilities are almost
endless.
In particular, I'm looking at the "Mode= " and "Database Locking Mode= ".
We're having problems with pivot tables linked to Access -- if the worksheet
is opened, the database becomes "read only". It's causing a problem with
many databases that are automatically updated, and are now not functioning.
Provider=Microsoft.ACE.OLEDB.12.0
Password=""
User ID=Admin
Data Source=T:\Teams\DatabaseName.accdb
Mode=Share Deny Write
Extended Properties=""
Jet OLEDB:System database=""
Jet OLEDB:Registry Path=""
Jet OLEDB
atabase Password=""
Jet OLEDB:Engine Type=6
Jet OLEDBatabase 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 OLEDBon't Copy Locale on Compact=False
Jet OLEDB:Compact Without Replica Repair=False
Jet OLEDB:SFP=False
Jet OLEDB:Support Complex Data=False
Where do they all get set? What are all the different variables. What do
they impact? Some of them are obvious, but a few are not. I have a couple
books -- but none go into that detail. With converting to Office2007, we
have pivot tables that were "convereted from Excel2003", some built from
scratch in Excel2007, and some created through MSQuery, many edited from old
Excel2003 worksheets. With multiple users, the possibilities are almost
endless.
In particular, I'm looking at the "Mode= " and "Database Locking Mode= ".
We're having problems with pivot tables linked to Access -- if the worksheet
is opened, the database becomes "read only". It's causing a problem with
many databases that are automatically updated, and are now not functioning.
Provider=Microsoft.ACE.OLEDB.12.0
Password=""
User ID=Admin
Data Source=T:\Teams\DatabaseName.accdb
Mode=Share Deny Write
Extended Properties=""
Jet OLEDB:System database=""
Jet OLEDB:Registry Path=""
Jet OLEDB
atabase Password=""Jet OLEDB:Engine Type=6
Jet OLEDB
atabase Locking Mode=0Jet 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
on't Copy Locale on Compact=FalseJet OLEDB:Compact Without Replica Repair=False
Jet OLEDB:SFP=False
Jet OLEDB:Support Complex Data=False