Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Unanswered: Problem with OpenRecordset and SQL Statement

    Hi there,

    Hope someone can help

    I am opening a recordset like this, where strDatabase is an SQL Statement

    Set rstDatafile = dbDatafile.OpenRecordset(strDatabase, dbOpenSnapshot)

    SQL Statement =[tblName] ORDER [Name]

    It opens and everything is seemingly OK. However I then run a loop that deletes records as per a set of criteria. If I run this on the same unaltered table I get different results each time. It's almost like the SQL statement is not ordering it the same each time.

    Am I doing something worng or is there another way to open a table order it's contents and modify it?

    Thanks for your time

  2. #2
    Join Date
    Oct 2003
    Provided Answers: 1
    Did you try to use dbOpenDynaset

  3. #3
    Join Date
    Jan 2005
    Yep no difference

Posting Permissions

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