Hi Chris,
thanks for your suggestion but i had already tried that.
i worked it out though and found that i needed to put square brackets around it
eg. lorecset.open ("select * from [cjc data]",loconnection)
thanks for your help though
always good to find out there are other Aussie foxpro people about :)
Jordan
Jordan Pastourel
Development Manager