Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    i wan to avoid DAO (Access 2000)

    Is there any other way to use my code shown below without the use of DAO or ADO? It is because we have different computers and we have to add manually the reference to the DAO library.SInce the computers are of different ages, to me the best solution would be to avoid the dependance of the library of the DAO.Is it possible to rewrite my code avoiding the use of DAO.I beg to be apolgized in case my question sounds stupid.
    My code is the the following:

    Dim intAnswer As Integer
    Dim stLinkCriteria As String
    Dim rst As DAO.Recordset
    strOrderId = InputBox("Enter Order number You Want to Locate")
    If strOrderId = "" Then
    Exit Function
    End If
    DoCmd.Close acForm, "frmCustomerOrders"
    DoCmd.OpenForm "FOrderinformation", acNormal, "", "", , acNormal
    Set rst = main.RecordsetClone
    rst.FindFirst "orderid = " & strOrderId
    If main.RecordsetClone.NoMatch Then
    MsgBox "

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: i wan to avoid DAO (Access 2000)

    No. I'm sorry, but if you're going to use a recordset, you have to use DAO or ADO and there isn't really a direct equivalent to a DAO recordsetclone in ADO. You can certainly clone a recordset in ADO, but the resulting recordset lacks the independence of the DAO recordsetclone.

    If your users have Access 2000 installed, then they all have DAO 3.6. If you have the Developer's Edition and distribute a runtime version, they will still have DAO, at least assuming you set a reference to it. Once you set a reference in your database, distributing to another machine will carry the DAO reference with it. It's only new databases that automatically default to ADO, and the version problems with that can be far worse than DAO versioning.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: i wan to avoid DAO (Access 2000)

    I really liked your answer. Have a nice day !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •