Unable to open query with Complex Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Running Access 2000. I have moved my database to a new machine with a newer
verions of Office 2000 installed.

One of my queries has a complex expression, and I can't open the query in
design mode in the original database because I get an error saying there is a
missing "]or ) ".

I can, however, run the query and get the appropriate results.

I have exported the query and table structures to create a 2nd DB with
different data, but I can't open the query in this DB either... though again
it will run.

I have exported the query to a test DB, without the data tables. In the
test DB, I can open the query in design mode, but the expression has been
truncated.

HELP - I need
1. to be able to use and modify the full expression in the original DB
2. to be able to use and modify the full expression in the 2nd DB.
3. export and use long and complex expression in my queries.

Any ideas on
1. what's wrong
2. how to open this bl**ping query
3. how not to have this happen again.

thanks in advance
 
Open the immediate window (Ctrl+G) and try:
? dbEngine(0)(0).QueryDefs("Query1").SQL
substituting the name of your query for Query1.

It that does not give you the SQL statement, try:
SaveAsText acQuery, "Query1", "C:\query1.txt"
Then examine the text file and extract the SQL statement.

If neither of these work, your database is corrupt and Name AutoCorrect is
the most likely suspect. Try the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
Back
Top