Hi,
I have to PC (1. access 2003 SP1; 2. Acces2002 SP3), same database with a table (Primary Key based upon three fields - cannot do differently because historical data for different items - ) containing roughly 1,000,000 recordsets.
When I perform an Action query (i.e. DELETE 500 records) on PC1 it will be performed easily, on PC2 it takes a while and then hangs->message pop up saying that a record is locked and is not possible to update it. I was told (if I correctly understood) that database lock records per page or per records; doing per page can generate this kind of problems. Does anyone have a suggestion on how could I get around this problem? Migrating to Oracle Server is a possibility, but a mid-term project.
Thank you in advance
filippo
I have to PC (1. access 2003 SP1; 2. Acces2002 SP3), same database with a table (Primary Key based upon three fields - cannot do differently because historical data for different items - ) containing roughly 1,000,000 recordsets.
When I perform an Action query (i.e. DELETE 500 records) on PC1 it will be performed easily, on PC2 it takes a while and then hangs->message pop up saying that a record is locked and is not possible to update it. I was told (if I correctly understood) that database lock records per page or per records; doing per page can generate this kind of problems. Does anyone have a suggestion on how could I get around this problem? Migrating to Oracle Server is a possibility, but a mid-term project.
Thank you in advance
filippo
