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

D

dim1ann

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting data with vba from Excel to an Access 2007 db with password 8
Problem creating PivotTable from ADO recordset using VBA 0
DateTime Data from Access to Excel using ADO 2
ADO Connection to Access leaves .ldb file behind 1
Data Not populating in Access database from excel form 1
ADO connection Problems between excel worbooks 0
troubles not bringing in the first row of a ado query to another spreadsheet... 2
excel form populating in access 2002-03 but not 2007 8

Top