I have successfully connected to PostgreSQL from Access97 and have even been able to make a query that gets it's results from several tables all at once. The problem is that no matter what I do, the ORDER BY clause of the query is ignored. I have set the sort criteria and I have tried with a pass-through query but the sorting always seems to come out in the order of the subtables that are joined to my main table.
I also have had a problem where I want to write a pass-through query but can't get it to execute without bringing up the "Select Data Source" dialog box. We are only ever going to use one data source and I know what it is so why do I get this message EVERY time I run the query? Is there some way to specify the DSN in the pass-through query so that I don't have to have my users do this everytime?
Thanks for your help,
len morgan