I have found solutions for this in Access2000, but how to capture a pass-through query into some code, so that user does not have to select a DSN and suply a password?
Users are still working with Access97 (and that is a pity).
The target database is SQL server 2000 and regular Jet-SQL queries all get fumbled when using linked tables.....
T. Blom
Information analyst
tbl@shimano-eu.com
Users are still working with Access97 (and that is a pity).
The target database is SQL server 2000 and regular Jet-SQL queries all get fumbled when using linked tables.....
T. Blom
Information analyst
tbl@shimano-eu.com
