Recordset.RecordCount

[pureenhanoi]

I'm using VB6 and MSAcces DataBase
my project have one Conection called: GPcnxn, a Recordset called: GPrs.
If i connect to database by DataEnvironment, so, after this command
Set Gprs=Gpcnx.excute("..."), i can get: Gprs.RecordCount, Gprs.AbsolutePossition
If i connect to database by DNS, so, after that command, both GPrs.RecordCount and GPrs.AbsolutePossition are return -1
i'll tried using : gprs.open sqlQuery,Gpcnxn,1,3. So, Gprs.RecordCount returns a valid value, but Gprs.AbsolutePossition still returns -1.
Please give me resolutions

[cmrhema]

I'm using VB6 and MSAcces DataBase
my project have one Conection called: GPcnxn, a Recordset called: GPrs.
If i connect to database by DataEnvironment, so, after this command
Set Gprs=Gpcnx.excute("..."), i can get: Gprs.RecordCount, Gprs.AbsolutePossition
If i connect to database by DNS, so, after that command, both GPrs.RecordCount and GPrs.AbsolutePossition are return -1
i'll tried using : gprs.open sqlQuery,Gpcnxn,1,3. So, Gprs.RecordCount returns a valid value, but Gprs.AbsolutePossition still returns -1.
Please give me resolutions

Try the cursor type as dynamic or keyset. if you are using cursor type as adopendyanmic set the cursor location as aduseclient. In keyset even if you do not mention the cursor location it will show(at least it worked for me). Or try cursor location=3
NOTE: I did not use DNS