Having encountered speed issues running accross an n3 connection on a WAN between front end and back end I decided to convert my backend to A97 however as soon as it started it failed to an invalid field type but di dnot give me any indication of what this could be and which table it resided in.

Has anyone any clues on this.

I have never heard of anyone downgrading to Access 97, the 2 versions are somewhat different. years ago when we migrated FROM 97 to 2000 the databases had to be converted and this would sometimes cause problems...it was ugly sometimes...

the only thing I could suggest is to check the References in the object library, but I don't see how going to 97 would improve speed issues?

When Access changed from 97 upwards it changed the code page size from 32 to 64. This meant that bloating increased as to the number of locked records either side of the chosen record. Using it purly as a backend means that the size can be controlled more efficiently. I know that from a front end point of view it is the wrong way to go but this was to experiment and benchtest data retreival.

David