Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converted 97 Access db to XP (Access XP)

    In a query that only shows 4 fields in design view shows all fields of both tables in dataview? Is this a conversion problem or what? Help <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converted 97 Access db to XP (Access XP)

    I found one problem. The "outputallfields" property for queries was set to yes. We switched it to no and that helps on new queries. The queries existing at the time of the conversion are still showing all fields.

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

    Re: Converted 97 Access db to XP (Access XP)

    Did you switch them to No as well?
    Charlotte

Posting Permissions

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