Recordset adLockReadOnly but still "currently locked by another user"!

Hello groups !
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14023-recordset-adlockreadonly-but-still-currently-locked.html

In a vbs script, I connect to an Access 2000 database and open a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14023
recordset for in readonly mode :

Dim oConn
Dim oRS
Set oConn = CreateObject("ADODB.Connection")
Set oRS= CreateObject("ADODB.RecordSet")

oConn.Provider = "Microsoft.Jet.OLEDB.4.0"
oConn.Open "Data Source=M:\mydb.mdb;User
ID=myuser;Password=mypassword;Persist Security Info=True;Jet
OLEDB:System database=M:\systemdb.mdw"

oRS.Open "Select Count(*) FROM mytable WHERE
somefield='somevalue'", oConn, adOpenForwardOnly, adLockReadOnly

On this last line, I get an error 80004005 : "Could not save;
currently locked by another user".

I know that another user might be accessing the database at this
moment, but I just want a count in readonly mode, why do I have
this message about "could not save" ?


Thanks for your help !

Regards
--
Arnaud

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Arnaud Lesauvage wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14023
> oRS.Open "Select Count(*) FROM mytable WHERE
> somefield='somevalue'", oConn, adOpenForwardOnly, adLockReadOnly
>
> On this last line, I get an error 80004005 : "Could not save;
> currently locked by another user".
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14023


It must be a pretty common error. Anybody has a clue ?

Regards
--
Arnaud