Our training courses

Other training resources

Our training venues

Why we are different

Details for Me&MyVBA

Me&MyVBA has participated in the following threads:

Added by Me&MyVBA on 10 Oct 2020 at 16:18

Hi Andrew, 

Awesome video and thank you. 

I think there are some bugs with the CopyFromRecordset property when using MySQL drivers. 

To be more specific, when I use this property then some of the fetched data come in a truncated version, say instead of Consumer Staples it is fetched as Consumer.

Having searched the web I found a property of the Recordset object as per below:

rs.CursorLocation = adUseClient

Indeed this addition provides me with a solution, but I quite do not get the reason why even when I read info in the link below. May I kindly ask you to elaborate on what this property does and its current value "adUseClient"?

https://www.w3schools.com/asp/prop_rs_cursorlocation.asp

Thank you

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...