Show Bid Request Database Problem Bid Request Id: 37343 Bookmark in my 'To Do' list Posted by: VBHelp (16 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 38.71% Buyer Security Verifications: Good Approved on: Nov 27, 2002 6:11:55 PM EDT Bidding Closes: Dec 11, 2002 6:20:20 PM EDT Viewed (by coders): 406 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: Visual Basic Enter chat room for this bid request (0 active users at Sep 8, 2003 8:33:00 PM EDT) Description: When I update a database record, the database file grows dramatically even though the data being saved hasn&'t changed at all. I need a solution to this so that the database stops growing to large. Attached is an example of the problem. The code is commented so you can see the problem. Please send back a working compiled copy of this to be considered. Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. Platform: Windows 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   cokey55 (2 ratings) in Cambridge, CambridgeShire United Kingdom Bid id: 407,175   N/A Nov 28, 2002 7:20:42 AM EDT  10 (Excellent)     Hey, This is MS Access doing what it does best...working ineffeciently. This is a common problem caused by access, you cannot stop this from happening, however you can compact the database in the code after a predetermined amount of time. I would not advise doing this after every update as it would cause a big delay. Attatched is your code with the compact_db routine. It has a new reference of the MS DAO object library. Regards Colin Woor Attached File           There are 4 private replies to/from cokey55. Click here to view them.