The coder will create methods to pull information from an Access 2003 ADP. The coder will create the following functions:
1. A function to return a list of column names, column type, and column length, and nullable/not null from a table. The function will take a path and a table name as a parameter and return an array of a custom Type (the coder will create this type).
public function GetColumnDefs(adpPath as string, tableName as string) as colDefType()
2. A function to return the name of the primary key of a table. If it is a composite key, it will return a comma delimited list of the columns for the composite key. The function will take a path and a table name as a parameter and return a string.
public function GetPrimaryKey(adpPath as string, tableName as string) as string
3. A function to return a list of index names, columns in the index, attributes from a table. The function will take a table name as a parameter. The function will take a path and a table name as a parameter and return an array of a custom Type (the coder will create this type).
public function GetIndexes(adpPath as string, tableName as string) as indexDefType()
## 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 Monday Oct 8, 2007 7:41:00 AM:
Per the original bid request the language that this is to be written in is VBA (Visual Basic for Applications) under Access 2003.
## Platform
Access 2003, VBA