Whenever I try to create a new recordset I get an error
saying: "Unable to retrieve tables from this connection, click on
the define...' button to test this connection." If I test my
connection it works fine. If I write the sql statement into the
advanced section I can even test it and it returns the correct
recordsets. Why is it doing this and what can I do about it?