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