Access 2000 to 2002 Selection to Union Query Conversion

[samsoldman]

I have a database that was created in Access 2000. I want to continue
to develop it in 2002 but when I try to open my main form (which is
based on a selection query), I get a syntax error and when I go back to
my query, it is now a union query (which I have never used before).

When I first open the database, the queries all look fine but as soon
as I try to open the form they are associated with, they are changed to
a union query. Converting the file to 2002 first does not fix the
problem.

Any suggestions?

Thanks in advance.

PS I need to take the file back to 2000 when I am done for my client.

 

[Vincent Johns]

I don't have a copy of your database that I could examine, but one
possibility is that there is a Module in the database that redefines the
Query. Or the database file could be corrupted. (Did YOU create the
database in Access 2000? If not, various interesting things could be
going on in there without your knowledge.)

If the file's corrupted, you might open a blank file in Access 2002,
using Access 2000 format (if Access 2002 will let you do that), and
import (don't link) into it all the objects (Tables, etc.) from the old
database file that you will need. That should leave the squirrels behind.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.