Greets all,

I am developing a n-tier application (UI - Biz Rules - Data Source) using a mdb (Access/Jet) file as my data source. I am interested in storing queries EXTERNAL to the mdb file. That way I could update the queries at anytime by replacing 1 file. (Let's say I optimize some queries at a later date or...gasp...find a bug!)

I access all my ADO stuff through middle-tier code and not any ADO objects on UI forms.

Maybe I could have my queries in one mdb file with links to tables in the other. But then I would have to make sure all the links were restored/current when the application was run. Hmmm. Any ideas?