I require a VB .Net form that allows me to select an MS Access Database of any version from version 97 onwards and then load the definition of all tables from that database. In particular I require the following information from each field:
Name
Type
Length
Precision
Scale
Is it nullable
Is it a Primary key
Is it a foreign key
Default Value
Is it an identity field
Place the values in a list view control or something similar. It is important to note that the project will not be accepted without ALL of the information!
## 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).
* * *This broadcast message was sent to all bidders on Thursday Jul 28, 2005 11:13:07 AM:
Hi,
It appears that my description may have been a little unclear.
To clarify I want to select a file that is an access database version 97 onwards.
The program is to interogate that database and get the names of all tables in the database. It must also get the definition of each field in each database table and retrieve the details requested in the original quote.
So pick a database and see a list of tables with every field in each table and all of the requested details of the fields.
I dont really care about the interface look and feel. All I really want is the information. I do not have the details of how to retrieve this information and I am looking to recruit someone that already knows how to get this information.
Important, all of the code to get the information must be in VB.net and none of it should reside in Access.
Please feel free t o ask questions.
## Platform
Windows .Net