9b74eb48_IntuiDev___Resources__Description
[Filename] Querying external DBs "on the fly" [(Access-) Version] >= A2000 [Size] 47kb [last update] 08/02/2005 [Description] 
This sample database shows how to query an external database "on the fly", that is, without linking any table of that external database to the current one. Instead, a SQL-string will be constructed that may be used from within code or that may be passed to i.e. a combobox or listbox. The MDB allows you to choose a database-file and will then display all tables and/or queries therein. After choosing a table or query, all records (if possible) will be pushed into a listbox. This approach is most useful i.e. in scenarios where multiple backend-databases are being used. In such cases, using queries as tables and simply modifying those queries' SQL-portion after the backend-database has to be changed will be way faster than using linked tables along with TableDef.RefreshLink.
IntuiDev - Resources
Description