>Thank you very much for your reply.
>
>Is it possible to create readonly recordsets by submiting queries joining two tables? I have done this successfully using ADO with the same provider in Visual Basic however it doesn't seem to work in ASP.
>
>Thanks in advance
>
>George

Yes it is. For example, a query like this works on a free table directory DSN: Select * from mytbl1 join mytbl2 on mytbl1.mrn_no=mytbl2.mrn_no. If it works in VB it should work in ASP too. One thing that could be different about the two environments is the permissions. What error message are you getting?