Query trouble with large tables (50,000+ records)

[SunGodly]

Okay, maybe someone can assist me here. I am developing an Access DB that I need to programmatically (TransferText method) import large amounts of PBX call data into. Getting the data in is fine but I have a couple of issues with manipulating the data once it is in. First, I have to delete a significant portion of the records (about 70%) as invalid data. Then, I have to convert a text field that holds a time stamp to Medium Time format (as text, it is formatted 24-hour without the colon; e.g, "1145" = "11:45 AM&quot.

I built a delete query with the proper criteria to delete the invalid records but I'm getting a "Could not update; record locked" error, so none of the records are deleted. As for the time conversion, I have an update query that inserts the missing colon but it finds a handful of records that are locked as well, so those are not updated.

I am at a loss as to why the records are locked, as they are not being used by any other part of the DB. To alleviate earlier problems with transferring the data, I have already adjusted the MaxLocksPerFile registry setting upward, and all the action queries' Use Transaction properties are set to No.

Can anyone suggest anything? I'll be happy to provide more information if required.

Thanks.

 

[SunGodly]

Okay, I moved the database to my local machine and am no longer having any problems. Of course, the application will probably have to reside on the server eventually, so does anyone have any thoughts?

Thanks again.