Recently i converted an access 2.0 database into access8.0/97 . Locally on my pc, the Access97 version runs at an acceptable speed. But over the network, the database runs very slowly.. The problem area seems to be a query that parses a table's record into smaller portions that are then input into another table. The queries on the 2 Access versions are exactly the same. Yet Access2.0 takes 2 second to do it and Access97 takes 10-20 minutes to reach a quarter and then pop up with a message saying "can't update; currently locked" .
[sig][/sig]
[sig][/sig]