Relation "tablename" does not exist

I have posted this before without receiving replies

My code is as follows:

Public dbRemote As New Connection
Public rsData As New Recordset

dbRemote.Properties("Data Source").Value = "DSM"
dbRemote.Properties("Initial Catalog").Value = "BCM_DSM"
dbRemote.Properties("User ID").Value = "johan"
dbRemote.Properties("Password").Value = "johan"
dbRemote.Open

rsData.Open "tblSuburb", dbRemote, , , adCmdTable


I receive the error "Relation "tblSuburb" does not exist"

Cheers

Johan van der Merwe
Ballenden & Robb Consulting Engineers
Tel (043) 743 3809
Fax (043) 743 9321
Cell 082 5530445

"I Don't want to be a human being, I want to be a human doing"

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.4/363 - Release Date: 2006/06/13