Create SQL Server db with VB and export / import to / from access
$30-100 USD
Completed
Posted over 19 years ago
$30-100 USD
Paid on delivery
**Important**: The same work to be done in VB6 then in VB.NET (2003)
Two parts:
**_Part 1._**
1. Create Form with 1 combo box, 3 lists (and other buttons, textboxes as needed)
2. Populate combo with list of SQL servers on form_load
3. when SQL server is selected from combo, (after user id / password is verified) the first list is populated with list of databases on that server
4. when a database is selected, the second list is populated with tables of that database
5. when table is selected the third list is populated with fields from the table.
**_Part 2._**
Create the following on SQL Server (and refresh the listviews on Part one as and when needed)
Create various parts on the form (buttons/text boxes, etc) to do the following.
**NEW Db**
1. Create new Database with a table with fields of different most common data types (date, memo, double, etc). Show in at least one case the definition of attribues (description, nullable or not, indexed or not, etc.
**Edit Existing Db** (pre-select from lists on Part 1)
1. Add new table to existing (selected) database
2. Add new field to existing table
**Export / Import** (preselect from Database items on part 1)
1. Export SQL Database to an Access database
2. Export single (selected from listview in part 1) Table from SQL Database, to an Access Db
3. Import / replicate Access Db with all tables / fields / etc to a selected SQL server
NOTE: (make up a test Access Db with a couple of tables, with various fields each af various data types)
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Win NT / 2000 / XP