General discussion

Locked

Access 2000/97 conflicts

By frec1 ·
I have one 97 database and I tried to run the 97 query in Access 2000 and I get the following:

You tried to execute a query that does not include the specified expression "COlumn name" as part of an aggregat function.

Could this becase it's a97 query, I'm tryig to execute in 2000.

FREC

FREC

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000/97 conflicts

by Benyo In reply to Access 2000/97 conflicts

There are real issues when running Access 97 databases in Access 2000. I find the best way is to open the 97 db in 2000 then save it as a new db. Then, run 'Compact and Repair Database'. I find this fixes most problems, but some complex databases may need their queries rewritten from scratch.

Collapse -

Access 2000/97 conflicts

by frec1 In reply to Access 2000/97 conflicts

Poster rated this answer

Collapse -

Access 2000/97 conflicts

by frec1 In reply to Access 2000/97 conflicts

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums