Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Jet 4.0 Index collection (DAO 3.6)

    I submitted an issue yesterday (Jan 8, 2002) where Relationships seemed to already exist, yet they could not have since the Relationship collection (DAO) was cleaned out.

    I have since found the cause. The Indexes collection of a tableDef includes relationships (and their names) in it. So when I go to restore Indexes, I "consume" the unique Relationship name in the wrong place. Has anyone else seen this in Jet 4.0 where the Indexes collection seems to include stuff that is NOT an Index?

    R

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

    Re: Jet 4.0 Index collection (DAO 3.6)

    Are you using combo lookups in Access tables? That creates an implied relationship with the table where you're looking up the values. Or are you talking about a different kind of relationship?
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet 4.0 Index collection (DAO 3.6)

    I'm doing this from VB, only in code. I'm iterating the TableDef.Indexes collection in DAO and getting values from the the DAO.Database.Relations collection mixed in with the Indexes.

Posting Permissions

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