Can anyone help me with this problem? This is what I've done:
1. I have a list of serial numbers in a seperate table.
2. I created a delete query using this table to delete the serial numbers in 2 seperate tables.
3. I tested it on a test copy of my database (on my laptop) and I run the delete query twice for each table and it runs perfectly and quickly. My list of serial numbers is 500 unique numbers. It deletes the 500 records out of my first table and 2500 out of my second table.
4. My problem is - when I import my delete query and table of serial numbers to the main database file on the network and run it, it 1.) takes 45 minutes to run (verses 5 seconds on my laptop) and I get a messages that says that 'your about to delete 500 rows from the specific table, once you click yes you can't use the undo command to reverse the changes'. When I click 'yes' another message comes back and says 'MS Access can't delete 0 records in the delete query due to key violations and 250 records due to lock violations. Do you want to run this action query anyways? To ignore the errors and run the query, click yes.'
5. I click yes and only 250 records are deleted. By the way, this database is replicated.
6. Why is it that I can run it when it is not on the network, without any problems. I have access rights.
7. Do you think that if I run the delete query on one of the laptop copies and synchronize it with the network copy that it would allow it?
I appreciate anyones help and expertise in this matter. Thank You, Kim
1. I have a list of serial numbers in a seperate table.
2. I created a delete query using this table to delete the serial numbers in 2 seperate tables.
3. I tested it on a test copy of my database (on my laptop) and I run the delete query twice for each table and it runs perfectly and quickly. My list of serial numbers is 500 unique numbers. It deletes the 500 records out of my first table and 2500 out of my second table.
4. My problem is - when I import my delete query and table of serial numbers to the main database file on the network and run it, it 1.) takes 45 minutes to run (verses 5 seconds on my laptop) and I get a messages that says that 'your about to delete 500 rows from the specific table, once you click yes you can't use the undo command to reverse the changes'. When I click 'yes' another message comes back and says 'MS Access can't delete 0 records in the delete query due to key violations and 250 records due to lock violations. Do you want to run this action query anyways? To ignore the errors and run the query, click yes.'
5. I click yes and only 250 records are deleted. By the way, this database is replicated.
6. Why is it that I can run it when it is not on the network, without any problems. I have access rights.
7. Do you think that if I run the delete query on one of the laptop copies and synchronize it with the network copy that it would allow it?
I appreciate anyones help and expertise in this matter. Thank You, Kim