Share via

Access 2010 - Error 3071 when making changes to query created in previous version

Anonymous
2010-11-18T03:18:03+00:00

I am doing some work for a client that has one machine on 2010 while the others are 2007.  The problem seems to occur when I make a change to query that was previously created.  Prior to making the change, the query was working but now I get the error 3071

  • "this expression is typed incorrectly or is too complex to be evaluated..."  I have also gotten this error when I tried to use a new field that was added to the table. 

Should I only do work on one computer?  Should I try to stay always in one version?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2010-11-18T03:24:22+00:00

    The rule of thumb is to always work in the lowest version. Of course you split the application in front-end (on each workstation) and back-end (on the server).

    -Tom. Microsoft Access MVP

    Was this answer helpful?

    0 comments