Solving my own question here; but thought I would post as it might help someone else down the line..... :oops: It’s not the wildcard on the LIKE. It’s the format of the date. Found out that MS-Access will be translating it through the ODBC layer based on locale. MySQL will expect it American nat...

Hi Getting stuck on this wildcard query. I've got a connection to the MYSQL database and a static query works; but this wildcard query won't - just returns a zero array: ***Query in MS Access to a linked table that works:*** SELECT postop.id, postop.case_number, postop.hospital_number, postop.record...

thank you. that works a treat

Hi Having an issue with getting CF_RESULT to work; so would appreciate any advice! The following script works perfectly and copies the database. It is running as domain admin account. However, it returns a CF_RESULT value of FALSE? //Set IGNORESPACES to 1 to force script interpreter to ignore spaces...