| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel connection to ODBC database | Excel Discussion (Misc queries) | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| Serial Letter- Connection with Excel database | Excel Discussion (Misc queries) | |||
| Database Connection from Excel | Excel Programming | |||
| MS Access Database Connection problem in Excel XP 2002 | Excel Programming | |||
Threaded Mode
