Access Fields

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