I am getting an intermittent message when I set the recordsource using an SQL. I have my SQL statement stored in a variable called sTemp. I get the error on:
Me.Form.RecordSource = sTemp
Sometimes it runs OK. I can run it again immediately and get the error, then run it again and not get the error. This is always using the same SQL statement.
The exact wording of the error is:
Run-time error '3146':
ODBC - call failed.
[Microsoft][ODBC Visual FoxPro Driver]Feature is not available.(#1)
The files in the SQL are linked files, on my C drive that no one else has access to. The SQL statement is:
SELECT prc59.po_number, prc59.po_date, prc59.s_name, prc59.s_address1, prc59.s_address2, prc59.s_address3, prc59.s_phone, prc59.s_contact, prc58.quantity, prc58.units, prc58.desc, prc13.partcode_1, prc13.unit_1 FROM (prc59 LEFT JOIN prc58 ON prc59.po_link = prc58.po_link) LEFT JOIN prc13 ON prc58.p_code = prc13.part_code WHERE (((prc59.s_code)='010078') AND ((prc59.po_number) = '04-8912'))
Thanks
Me.Form.RecordSource = sTemp
Sometimes it runs OK. I can run it again immediately and get the error, then run it again and not get the error. This is always using the same SQL statement.
The exact wording of the error is:
Run-time error '3146':
ODBC - call failed.
[Microsoft][ODBC Visual FoxPro Driver]Feature is not available.(#1)
The files in the SQL are linked files, on my C drive that no one else has access to. The SQL statement is:
SELECT prc59.po_number, prc59.po_date, prc59.s_name, prc59.s_address1, prc59.s_address2, prc59.s_address3, prc59.s_phone, prc59.s_contact, prc58.quantity, prc58.units, prc58.desc, prc13.partcode_1, prc13.unit_1 FROM (prc59 LEFT JOIN prc58 ON prc59.po_link = prc58.po_link) LEFT JOIN prc13 ON prc58.p_code = prc13.part_code WHERE (((prc59.s_code)='010078') AND ((prc59.po_number) = '04-8912'))
Thanks