I'm having a problem opening foxpro tables in access. The error i get is "Unexpected error from external database driver (8961)". Now I can cope with that, but what's troubling me is I only get this happening with tables that have been created in foxpro from SQL-selects where I've included the keywords LEFT or RIGHT in the selects.e.g.;

This opens no problem:
SELECT field1, field2, field3
FROM first_table
OUTER JOIN second_table
ON first_table.keyfield = second_table.foreign_keyfield

This doesn't:
SELECT field1, field2, field3
FROM first_table
LEFT OUTER JOIN second_table
ON first_table.keyfield = second_table.foreign_keyfield

Anyone know what's going on? I'm using Visual Foxpro 5.