Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    May 2003
    Location
    London, Gtr London, England
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Jet Database Error 3070 (97)

    I am confused.
    1. I have created a Base query.
    2. I created a crosstab query based upon the Base query.
    3. I created a report based upon the crosstab query.
    4. All worked fine.
    5. Now I have created another crosstab query based upon the original Base query.
    6. This crosstab query works fine.
    7. Now the new report based upon this new crosstab query does not work: I keep getting this error message that does not make sense to me:
    The Microsoft Jet database engine does not recognize <name> as a valid field name or expression. (Error 3070)
    The field is BaseQuery.LastName

    What's up?????

    Louis

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: MS Jet Database Error 3070 (97)

    Could it be something in your grouping/sort selections in the report?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Lounger
    Join Date
    May 2003
    Location
    London, Gtr London, England
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Jet Database Error 3070 (97)

    It does not appear to be that.
    After trying it a number of times, opening in design, saving, running it, and adding a field in design, I finally got it to work.

    However, when i tried to talk a friend thru the process over the phone, she got the same results.
    Can't figure it out.

    Soc

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

    Re: MS Jet Database Error 3070 (97)

    Just run the query and look at the column headings. If one of them is BaseQuery.LastName, rather than just LastName, that could be your problem.

    On the other hand, crosstab queries as report datasources can cause problems, especially if there's a parameter somewhere in the mix. Since crosstabs are dynamic queries, they normally only return columns where data exists You might try setting up column headings in your crosstab so that the columns will always be returned even if no data exists for them and see if that cures your error.
    Charlotte

  5. #5
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Jet Database Error 3070 (97)

    The MS Knowledge base has this article for Access 2000 but I think that it applies to A97 as well
    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q209/7/78.ASP>http://support.microsoft.com/support/kb/ar...s/Q209/7/78.ASP</A>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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