Hi all,
i am connecting to an Access database through the Jet engine which all works just fine, until i come to the point of trying to open a table where there is a space in the table name eg. "cjc data".
what i am currently doing is trying to open the table in a recordset object with

lorecset.open ("select * from " + table1,loconnection)

but it falls over when i gets to the space because it thinks the table name in just "cjc".
how do i get arond this?

thanks
Jordan