473,385 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

ado connection with excel pivotcach-problem compact db

dim
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 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

Nov 13 '05 #1
0 1231

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andrew | last post by:
Hi, How can I make a connection to an Excel file, and I can select the specific fields? For example in sheet1: A B C 1 20 change good 2 short return ...
11
by: Frank Xia | last post by:
When I try to build a oedb data connection, I got an error message saying "Invalid path or you have to connect to the server the database is resided". I can see dataset through Data - Preview...
8
by: Peter Larsson | last post by:
Hi there, I've recently developed a VBA-program in Excel that fetches and presents data from a distant Access database over a wireless peer-to-peer network (both computers running Win XP Pro)....
7
by: soubhagya | last post by:
hi.. I need to open an excel file and read particular rows column data from particular worksheet and write to another excel file. this is to be done with "C" program..Right now I have no...
2
by: Ann Marinas | last post by:
Hi all! I know this post is kinda silly, but I'm just curious... How can you build a database connection string using an excel file to get your data? Thanks a million!
1
by: PAM | last post by:
Hello I'm a newbie trying to open a connection to an Excel file in a deployed ASP .NET app and get the error Dim MyCommand As New OleDbCommand(mySelectQuery, MyConnection MyConnection.Open(
4
by: zino | last post by:
in VB.net (windows form): the function is reading 2 colums x 1000 rows, from an excel file, loading them in a datatable then add the datatable to a dataset. How can I send this dataset to the...
1
by: funcSter | last post by:
I want to retrieve data from an Excel file like how I would with a database. I understand that I would have to use OLE DB. Somehow I think I cannot get the connection string right, as the bit of...
6
by: William Foster | last post by:
Good morning all, I want to password protect a Microsoft Excel Workbook containing all my reference tables for a program, so that I can place the workbook in a central location that is...
1
by: SeeMe | last post by:
Hi, I using Microsoft Visual Studio C# 2003, Microsoft Office Excel 2003 and using IIS server. I added Microsoft Excel 11.0 Object Library refrence. 1. Software not allow me to write this code:...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.