Show Bid Request VB code to backup an open Access 2000 db every hour Bid Request Id: 14133 Bookmark in my 'To Do' list Posted by: infomed (37 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 14.81% Buyer Security Verifications: Good Approved on: Apr 20, 2002 8:45:39 AM EDT Bidding Closes: May 4, 2002 9:04:42 AM EDT Viewed (by coders): 324 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Language Specific, Visual Basic Enter chat room for this bid request (0 active users at Sep 8, 2003 8:08:59 PM EDT) Description: I am looking for brief, cheap, and well commented code to regularly back up an Access 2000 database. The code must: 1. Allow me to ask a user where they would like to back up their db.mdb database (using a common dialog mechanism get the path to the folder they want to have the backup saved). 2. Automatically back up the database every hour, even if the database is open and being used. The prior backup needs to be renamed to reflect that it is an older back up and not the most recent. In other words, when the timer reaches an hour, the db.mdb database (which may be open and being used) will be copied and saved as dbNOW.mdb. If there was a dbNOW already present (e.g., from the backup done an hour before), it will be renamed db1HOURAGO.mdb. If there was a db1HOURAGO.mdb, that database will be renamed db2HOURSAGO.mdb. If there had been a db2HOURSAGO.mdb, that database can now be deleted 3. This code must be written in no more than 2 or 3 procedures and, once set up, must run behind the scenes with an alert only if a problem arises. Thanks! I look forward to seeing good solutions. If you have a different or better way of solving this problem, I'd like to hear it. (I generally pick from those who send a working demo.) Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Platform: win 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! KVIC (28 ratings) in Tomsk, Russia Russian Federation Bid id: 154,716   $20 (USD) Apr 20, 2002 11:16:02 AM EDT  9.68 (Excellent)     I made program for copy database (VB6, SP4). For testing - you press command button 'Make copy'- 3 or more times and you will get all copies. In real version I will add timer and settings for it. And I have some additional proposals. Try to make copy when your database is used by another application(s). Attached File           There are 7 private replies to/from KVIC. Click here to view them.