Access97 Query expression truncated by Access2000

From: Bilbo (Bilbo_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 15:37:04 -0800

I wrote a database for a customer in Access97, and it works fine.
The customer upgraded to Access2000 and I converted the Access97 database to
Access2000 format.
It continued to work fine.

However, after adding some functionality to one of the forms, the customer
discovered a bug in a seemingly unrelated function.

This bug turned out to be related to a wording change in the updated form.

In order to resolve the bug, I had the customer open the effected query in
design view and change the criteria to relect the new wording used in the new
form.

However, when closing the design view we received an error indicating a
required character was missing from an expression, but the referenced
expression had not been edited by us!

Going back into design view we discovered an expression had been truncated
without us touching it at all. The only way to close the query was to
discard all changes, including the required change of criteria.

We tried several different methods, and views to make the changes, all
unsuccessful until I broke down and wrote the query in Access97 and emailed
it to him in an otherwise blank database. He was able to import the query to
his Access2000 version (without opening in design view), and now the query
works fine (complete with the corrected criteria, AND the expression which is
too for design view.

I even tried opening the query in SQL view, but it would not allow it with
the truncated expression.

PLEASE HELP ME!

Was there some limitation added in the change from Access97 to Access2000?
If yes, does the limitation carry over to newer versions such as AccessXP or
Access2003?
Is there another work around so I can avoid the need for two duplicate
databases?

Thanks in advance!

Relevant Pages

  • RE: form updates the table, but the query doesnt show it
    ... (the feeling that i'm going to have to rebuild this database from scratch ... repair information. ... the lines of Pertaining to Customer Claim of Trouble vs. Pertaining to Repair ... based it on the query. ...
    (microsoft.public.access.queries)
  • form updates the table, but the query doesnt show it
    ... formed the original database with intent to make it more efficient / logical ... repair information. ... the lines of Pertaining to Customer Claim of Trouble vs. Pertaining to Repair ... based it on the query. ...
    (microsoft.public.access.queries)
  • Re: order by property in a table
    ... SQL or query that retrieves the records, or some property of the display (a ... Do you have the database you are developing separated into a front-end ... > create a database to track customer traffic, not customer information). ...
    (comp.databases.ms-access)
  • Re: Classes - Dumb question
    ... have to code for the unique qualities of that kind of customer. ... such as customer login, database, stuff like that? ... public function __construct($server, $username, $password, ... Notice how the details of connecting and running a query (like the ...
    (php.general)
  • Re: How to go from Excel to Access - pointers / methods
    ... I have a flat table with customer, date, use and billed amount. ... As a relational database, Access's functions and features ... If you want to see a month's usage, use a query against the usage table. ... The Excel spreadsheet of customer names, date, water use, charges for the ...
    (microsoft.public.access.gettingstarted)