OpenRecordSet on CurrentDb

[plarsen]

Hi all

Why can't I use the 'Dim dbs as Database' in Access 2002 (XP)?

How do I use OpenRecordSet in Access 2002?

I have tried 'Set rst = currentDb.OpenRecordSet("SELECT * FROM tblTable&quot', but it says 'Type Mismatch'

Thanks in advance!

Kind regards

Peter Larsen

 

[KenReay]

Hi

Because you need to set a reference to the DAO library

Open any module in desgin view, choose tools \ refernces from the menu, select the Microsoft DAO library

For good measure quailify you dim statements so:

Dim Db as DAO.Database
Dim rs as DAO.Recordset
...etc

to avoid confusion with ADO objects

Reason:

In Access97, DAO was default object library for data access, fron Access2000 on, ADO is the default library for data access, and if you want to use DAO (which you are), then you need to specificly load the library.

The other alternative is to learn and use ADO commands


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK