Show Bid Request ODBC Connect! Bid Request Id: 1635 Bookmark in my 'To Do' list Posted by: GIGO (25 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 40.38% Buyer Security Verifications: Unverified Approved on: Aug 14, 2001 9:29:39 AM EDT Bidding Closes: Aug 17, 2001 9:35:05 AM EDT Viewed (by coders): 676 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: Windows, Database, Visual Basic Enter chat room for this bid request (0 active users at Sep 23, 2003 2:52:50 PM EDT) Description: I am have developed an application that is heavily reliant on Data Access for data input. The issue is that I have to use several (but seperate) databases for the several users of the app and do not want to use multiple data controls in my app as this will be too hard to maintain in the event that I want to upscale the app and of course this woul mean hard coding evertime I need to doo this. So basically, I have to find a way to influence the database called by the app for input when the user enters their Id#. The table and fields in all the databases will have the same names but the string to connect to "the specific database" relating to the user is what I need a code to invoke at run-rime. Simply put, the code must be able to invoke the recordsets one of several databases by defining it in code using one of the several data controls methods. The ideal scenario will be that if User #1's ID is say 2842356, then "invoke the db (named user ID on C: drive" by changing the db in code. I hope this is easily done or has ben done b4 as I need this project completed urgently. Deliverables: Complete source code of all programming work done Special Conditions / Other: Max. 1 week; to include testing and refinement and delivery of final code etc. 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! psiclone (5 ratings) in Durham, DURHAM United Kingdom Bid id: 14,272   $60 (USD) Aug 14, 2001 6:42:56 PM EDT  10 (Excellent)     Hi GIGO, from what you are describing, this sounds like a straightforward code optimisation project. I would be happy to do it.