Johan van der Merwe wrote:
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 = "user"dbRemote.Properties("Password").Value = "password" dbRemote.Open rsData.Open "tblsuburb", dbRemote, , , adCmdTable I am getting an error "relation tblsuburb does not exist" Where am I going wrong?
It's telling you - the object "tblsuburb" doesn't exist (this could be a table, sequence, view or anything else).
Are you looking at the right database on the right host? -- Postgresql & php tutorials http://www.designmagick.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
