Re: AW: MaxDB with Access Linked Tables

2004-05-17 Thread Sim Zacks
e to use so called Passthrough-Queries. This means Access will send the query, without any processing, to the selected source. Peter -Ursprüngliche Nachricht- Von: Sim Zacks [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Mai 2004 09:40 An: [EMAIL PROTECTED] Betreff: MaxDB with Access Lin

AW: MaxDB with Access Linked Tables

2004-05-17 Thread "Hübschen, Peter"
n or maybe "case"), you have to use so called Passthrough-Queries. This means Access will send the query, without any processing, to the selected source. Peter -Ursprüngliche Nachricht- Von: Sim Zacks [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Mai 2004 09:40 An: [EMAIL PROTEC

MaxDB with Access Linked Tables

2004-05-16 Thread Sim Zacks
I am trying to convert a project from Access to MaxDB backend with an Access frontend. I am having a slight problem with case sensitivity and the Like predicate. Access won't pass the Upper function through and returns an error that it is an undefined function. I tried using StrConv, the Access fu