You probably need the 64-bit version of LINQPad since you have the 64-bit Access/drivers installed (look for the message Running massive queries in LINQPad 5? on the download page). I'm not sure if it will work with the script I provided with no other changes, as I've never used 64-bit Access and don't have a machine with it installed that I can experiment with.
20266 Operation not supported (2 Viewers)
- Thread starter mellamokb
- Start date
isladogs
Access MVP / VIP
- Local time
- Today, 00:43
- Joined
- Jan 14, 2017
- Messages
- 19,391
Thanks
I downloaded the 64-bit version of LINQPad with the following results
Anyway, assuming I've now correctly understood the problem, I'm happy to inform the Access team about the issue tomorrow.
I'll let you know if I get a response.
I downloaded the 64-bit version of LINQPad with the following results
- Using CC version 2511 19426.20186 64-bit, the script failed on the line var rs = .... with the error Operation is not supported for this type of object
- Using Beta version 2601 19611.20002 64-bit .... same error
- Rolling back to CC 2509 19231.20216 64-bit . . .success
Anyway, assuming I've now correctly understood the problem, I'm happy to inform the Access team about the issue tomorrow.
I'll let you know if I get a response.
Last edited:
Awesome glad to hear! Yes this is exactly the issue, appreciate your help in reviewing this. And thanks for your patience sorry for all the posts to get to the explanation. I really hope they plan to fix this but I could understand we are probably well outside of normal usage.
Similar threads
