Error on line set pvtCache = dbRecordset.recordset
Hi,
I am getting an error "Application-defined or object-defined error : 1004" on the highlighted line below.
I cannot use ADODB or DAO because I am on Win 64-bit machine. But it should still work I assume so what is it that I am doing wrong here?
Please Login or Register to view this content.
Can anyone please help me out with this?
what do you mean by that? the recordset has to be one or the other, and you need ADO as far as I know (you have DAO)Originally Posted by fadydaddy
Josie
if at first you don't succeed try doing it the way your wife told you to
Whenever I declare Dim dbRecordset as ADODB.Recordset, it doesn't compile. However I am able to do my operations if I use the Access Object Library. But why am I getting this error?
you need to set a reference to the 'microsoft activex data objects library' to use ADO. like I said, you can't use a dao recordset for a pivotcache as far as I know.
Well, that I can't. Win 64 bit does not compile ADO.
that's just not true.
If I use this code (with references set to ADODB library 6.0) then I get runtime error 3706 for application defined or object defined error on the linePlease Login or Register to view this content.Please Login or Register to view this content.
you need to use the microsoft.ace.oledb.12.0 provider.
I don't have that. You see I am sitting on a Citrix desktop compiling this. There is no reference for that available.
it's not a reference - it's the provider string you should use instead of microsoft.jet.oledb.4.0
https://www.google.ae/#hl=en&safe=of...w=1024&bih=628you will find a lot of issues win Win 64 under these results
are you telling me it doesn't work? I already told you not to use the Jet provider
This solved it. Thank you for your patience and help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks