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
Jordan Pastourel
Development Manager