Software

Ask something
Discussion Locked

Access 2000/97 conflicts

0 helpful
3 replies

by frec1 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by benyo

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.

This discussion is closed to new replies.