I am stuck on a project for which I need specialist advise.
I am trying to set up a simple queuing system whereby a number of machines running Excel 2007 have access to a SQLite database hosted on an NFS drive.
The goal of the system is for each machine to query the queue table to check whether there are any records in the queue that need to be processed. If the query returns a record then the status of that record is updated such that other machines do not pick it up for processing. Once processing is complete, we then start the process again.
I have all constituent parts working fairly well but am running into 'database locked' errors. This is is spite of handling such errors by having the machine ignore such error, wait one second and try again.
I have attached to this post a working example of the code which works fine for one machine but breaks down as soon as another is introduced.
I am prepared to pay $150 dollars to get the answer to this problem..even if it takes...