Connecting to external db via query to populate dropdown boxes (1 Viewer)

[prgwhiting]

I want to connect as and when needed to an external database, in order to use it's tables to populate my drop down boxes. I can connect and disconnect no, problem, but have been warned that this may cause expensive overheads regarding bloat etc. Someone mentioned creating a query to connect to the tables in the external database, stating that this lessens the overheads. Can someone please publish an example of doing this.

Thanks

 

[Pat Hartman]

The most efficient method is permanent links rather than linking when the db opens or worse, every time the form opens.

You can find an example of a query that references a non-linked table if you look up the In clause in help. This method should actually be the least efficient since it requires that Access go through the linking process every time the query runs.

[This message has been edited by Pat Hartman (edited 04-18-2002).]