Show Bid Request Database Connection in VBA via ADO Bid Request Id: 19492 Bookmark in my 'To Do' list Posted by: Alien0Cool (2 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Unverified Approved on: Jun 18, 2002 5:29:58 PM EDT Bidding Closes: Jun 20, 2002 10:31:20 AM EDT Viewed (by coders): 229 times Deadline: 6/22/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Database, Language Specific, Visual Basic Enter chat room for this bid request (0 active users at Sep 23, 2003 2:40:55 PM EDT) Description: I have to get my program in Visual Basic 6.0 to access a database on SQL Server via ADO. I need the program to gather all of the table names in the database and store them on a database list control. Then when someone clicks on one of the tables in the database list control, I need all of the columns in that table to appear in another database list control beside it. Finally, when someone clicks the column I need a description to show up on the program describing the column and if a description is not there, I need to find a way to add a description to that column and store it in another place for future reference. 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: Windows 2000 Must be 100% finished and received by buyer on: Jun 22, 2002 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. 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! CSK (22 ratings) in MELBOURNE, VICTORIA Australia Bid id: 214,111   $39.75 (USD) Jun 18, 2002 6:38:41 PM EDT  10 (Excellent)     For the above bid amount I will give you a program that will allow you to connect to a database (hardcoded but can be changed) on an MS SQL Server via ADO based on the server's IP address or NetBIOS name (hardcoded but can be changed). It will then display a list of tables in that database in a listbox. On selecting a table from this list, it will show a list of fields in that table in another listbox. On selecting a column, a description of the column will be shown, along with functionality to add new descriptions, that I will store in an MS Access database.