ado connection with excel pivotcach-problem update/delete,etc database
 

hi
need little help:
i'm querying access 03 tbls using ADO from excel and loading recordset
into pivotcache...query built dynamically in vba (excel)..
rs.Open szSQL, , , , adCmdText


when recordset is loaded into pivotcache
Set PTCache.Recordset = rs
and pivot is built by a user
i can't update/compact database as message tells me that db
exclusively
opened by such a user..
is any other approach without getting into complications of setting up
security on db ???
( i tried to find a fast way of putting security on db but i'm not good

at it )
so i thought a solution could be in recordset or connect objects?
thanks in advance
Dim