Show Bid Request
Network Locking with Access
Bid Request Id: 42012
|
|
|
|
Posted by: |
Dan (4 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
|
Posted: |
Jan 2, 2003
11:56:07 PM EDT
|
|
Bidding Closes: |
Jan 4, 2003
1:00:00 PM EDT
|
|
Viewed (by coders): |
158 times
|
|
Deadline: |
1/6/2003
TIME EXPIRED
|
|
|
|
|
Description:
I am trying to use an Access Database to write data to from a FoxPro database - both on different drives on a LAN. This really has nothing to do with the FoxPro side - that just happens to be where this data is coming from. What I need to accomplish is for multiple stations to be able to access and write to a Access Database at the same time without getting locking errors. The code I am using will do that for small amounts of records but the attached code is running a batch from FoxPro that contains 45,000 + records and all need to be placed in the Access File. Every time I try to do this across the LAN I get a locking error and the program crashes. Usually happens about 200 - 400 records into the program. I need someone to give me an example of how to code this so that I have a dependable connection that will add the records to the Access Database but maintain open so that other stations can maintain connection to the file adding records as well. I have placed the code in a word document for you to review.
Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of example of how to have multiple stations access and write to an Access Database at the same time with one station running the attached code with 45,000 + records.
Platform:
VB 6.0, windows 98, Access 2000
Must be 100% finished and received by buyer on:
Jan 6, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$15 (USD)
|
Jan 3, 2003
9:07:44 AM EDT
|
9.4
(Superb)
|
|
|
Hello Mr. Dan,
Coincidently The same problem we faced for another database(informix) when the live database started exceeding records to 50k.
The apporach you have taken is not the correct one. It increases the time multifolds, also concurrency is not observed.
Also there seems to be some strange approach for displaying the number of records updated. There is no need to add -Do Events and that wait (your own function maybe- code.
Just accpet the bid and rest assured. We will have your problem sorted within half an hour once we know of the bid accpetance.
regards
VBMasterZ
---------More------------
We are a group of programmers with over 4 years of experience in VB/ASP/C applications and Access/MSSQL/Oracle/MySQL databases.
We have till date woked on 40+ database projects and 25+ other interestign projects.
QUALITY AND SATISFACTION GUARANTEED!!! |
|
|
|
|
|
|
