Re: 97 to 2000 format

Max wrote:
> another error
>
> Set rst = dbs.OpenRecordset(strSQL)
>
> "Rick Brandt" wrote:

Both DAO and ADO have a Recordset object so I should have mentioned that in
addition to adding the reference for DAO you need to remove the one for ADO.
Otherwise you have to disambiguate all objects that exist in both libraries.
Instead of...

Dim rst as Recordset

....use...

Dim rst as DAO.Recordset.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Database access sucks!
    ... > I don't agree with you about DAO though, you should NOT use DAO - it ... .Net changed a lot from DAO, ADO, and OLEDB. ... >> a Recordset object as it was in the older versions within .NET and it ... >> I've used other environments. ...
    (microsoft.public.dotnet.general)
  • Re: Database access sucks!
    ... I don't agree with you about DAO though, you should NOT use DAO - it sucks. ... .Net changed a lot from DAO, ADO, and OLEDB. ... > a Recordset object as it was in the older versions within .NET and it ... > and I still used the old components for these applications. ...
    (microsoft.public.dotnet.general)
  • Re: save any property from vba
    ... Everything will become extinct 'one of these days' but DAO will continue to ... be supported at least as long as 'classic' ADO. ... Dim aob As AccessObject ... Dim rst As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: subform
    ... ADO (the alternative is to use DAO) recordsets. ... Dim rst As DAO.Recordset ... > name and ssn from the form to the recordset. ...
    (microsoft.public.access.formscoding)
  • Re: 97 to 2000 format
    ... > Both DAO and ADO have a Recordset object so I should have mentioned that in ... > addition to adding the reference for DAO you need to remove the one for ADO. ... > Dim rst as Recordset ...
    (microsoft.public.access.modulesdaovba)