>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

Anthony,
don't take this as gospel, but I think it may have something to do with CursorLocation = 3 (client side cursor ) it might work with a SQL statement as the records would be pulled down the wire, try leaving it server side ( default )
let me know how you get on
Pete Kane