I am trying to run a maketable query from a access97 database that will be scheduled to update an access 2000 database. Of course the formats are not compatable, is there any way to hack around this? Any help would be greatly appreciated.
No, A97 cannot work with newer file types. That is the way it is with ALL applications, not just Access. The programmers who built A97 in 1995 and 1996 would have no way of knowing what changes would be made to Access for A2k so there would be no way to forsee the format change.