SQLITE VBA NFS INTEGRATION
3129
£100(approx. $125)
- Posted:
- Proposals: 4
- Remote
- #886422
- Archived
Description
Experience Level: Expert
Estimated project duration: 1 day or less
Hi there,
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 you two minutes to figure it out. I will expect a phone call / email explaining what I am doing wrong and stepping through the solution
Many thanks,
Duncan
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 you two minutes to figure it out. I will expect a phone call / email explaining what I am doing wrong and stepping through the solution
Many thanks,
Duncan
Duncan E.
100% (8)Projects Completed
13
Freelancers worked with
11
Projects awarded
60%
Last project
22 Dec 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies