HELP.
Im using the VB6 Data Designer to create recordsets from an MS Access
database.
I am "trying" to use the SQL Builder.
Whenever I set a table join to an Outer Join, The SQL Builder creates the
SQL statement in Oracle format with the "{ oj " indicator at the begining of
each join.
When I do a 'Verify SQL', SQL Builder reports a syntax error in the FROM
clause and the query will not run.
If I remove the '{ oj ' indicators everything works Ok.
However, if I make any change to the query,  SQL Builder puts all the
incorrect syntax back in.
The Connection Data Provider is set to 'Microsoft Jet 3.51 OLE DB Provider'
so why does SQL Builder insist on generating the Oracle syntax for outer
joins then tell me the syntax is incorrect.
If I set the Data Provider to 'Microsoft OLE DB Provider for SQL Server' and
do an outer join on two SQL Server tables, the generated SQL syntax is Ok.
Thanks in anticipation.
Paul Thompson