By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

Type mismatch

P: n/a
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)
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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)

Nov 12 '05 #2

P: n/a
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)


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.