You need to tell open how to evaluate the source
try - ors.Open("Area", oconn, 3, 1, 2)
2 = adCmdTable
Syntax
Open Source, ActiveConnection, CursorType, LockType, Options
This works in 2.0 for me
Geno
>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