Yes, but when you connect using OLEDB or ODBC, you cannot see certain types
of query (e.g. parameter queries, queries that invoke functions defined in
Access in VBA ("user-defined Access functions", queries that invoke certain
other built-in Access VBA functions (mainly the financial time series ones),
some Union queries etc.) Also, queries that use the older "?" and "*"
wildcards in "LIKE" expresions will not work with OLEDB.
IN most of those cases, you have to connect using DDE In the case of the
wildcards, you can switch everything over to the newer syntax (SQL-92) in
Access and use "_" instead of "?" and "%" instead of "*". But that's quite a
big move in some cases and needs to be thoroughly tested before you commit.
Peter Jamieson
