I'm having some problems trying to use ADO with a table. I can get it to work with a Select statement but haven't had much luck with a table. Am I supposed to be able to access a table directly? I can't see why I shouldn't be able to. The commands that work are:

oConn = CreateObject("adodb.connection")
ors = CreateObject("adodb.recordset")

oconn.Open("DSS")
ors.cursorlocation = 3

ors.Open("Select * from Area",oconn,3,1)

BUT when it doesn't work when I try:

ors.Open("Area",oconn,3,1)



Has anyone got any ides why this might be happening?

Thanks

Anthony