Access 97 Query Size Limit
Does anyone know, is there a limit to the size that a query in Access 97 can be? It's been years since I've looked at Access at all.
I've been asked by a client to look at an Access 97 db which is used as an interface between 2 systems.
The db is a goliath of a system that has been built up over many years and although doesn't handle a massive amount of data at anyone time or stores it (data comes in reformated,validated and reported on and then goes out again), they are starting to have some memory issues with it.
Firstly, the data and database never exceed 2GB and the tables don't exceed 1GB although you may have over 100,000 records in a table so I'm pretty sure it's not here. One of the queries which does validation is stupidly large (about 4 A4 pages if you extract the sql and put it into word at 8pt!!)
The client isn't acceptable to a) upgrading this db to say Access 2000 at least, b) having a purge of redundant code, c)doing this work in the destination db which is on Oracle and already has the facilities.