Can i search for records in more than one .odb file with one query ?
Not really. Instead, use a macro to:
- Connect to the other database.
- Run a query to pull in the data.
- Run a query on the local database based on these results.
Or, a macro could copy the data from that database into a table in the local database. Then a single query could join both tables.
Related: Multiple databases
Although somewhat obscure, certain databases (and what might be referred to as a database - read as schemata) provide a method for this. One example is PostgreSQL with ‘dblink’ extension installed or possibly ‘postgres_fdw’.