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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement