Type mismatch

[Ronny Sigo]

Hello all,
the code below gives me a "Type mismatch" err message on the last line.
Can anybody help me with this?
(Microsoft DAO 3.6 object library is referenced)

Many thanks!
Ronny

Dim dbsMybase As Database
Dim rst As Recordset

Set dbsMybase = OpenDatabase("\\Mypath\MyFile_be.mdb")
Set rst = dbsMybase.OpenRecordset("tblDhscmails", dbOpenDynaset)

[Allen Browne]

The ADO library also has a Recordset object.
Be specific about which type you want:
Dim rst As DAO.Recordset

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ronny Sigo" <ro********@skyynet.be> wrote in message
news:40*********************@news.skynet.be...

the code below gives me a "Type mismatch" err message on the last line.
Can anybody help me with this?
(Microsoft DAO 3.6 object library is referenced)

Many thanks!
Ronny

Dim dbsMybase As Database
Dim rst As Recordset

Set dbsMybase = OpenDatabase("\\Mypath\MyFile_be.mdb")
Set rst = dbsMybase.OpenRecordset("tblDhscmails", dbOpenDynaset)

[Ronny Sigo]

Hi Allen,
Works great!
many thanks
Ronny
"Allen Browne" <Al*********@SeeSig.Invalid> schreef in bericht
news:40***********************@freenews.iinet.net. au...

The ADO library also has a Recordset object.
Be specific about which type you want:
Dim rst As DAO.Recordset

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ronny Sigo" <ro********@skyynet.be> wrote in message
news:40*********************@news.skynet.be...

the code below gives me a "Type mismatch" err message on the last line.
Can anybody help me with this?
(Microsoft DAO 3.6 object library is referenced)

Many thanks!
Ronny

Dim dbsMybase As Database
Dim rst As Recordset

Set dbsMybase = OpenDatabase("\\Mypath\MyFile_be.mdb")
Set rst = dbsMybase.OpenRecordset("tblDhscmails", dbOpenDynaset)