Application in VB6

We generally open the Specific Database from the Application, VB project. But I want to create that application which can open any Access Database file at any location in the run time.

I have got the solution of this problem up to open the Database, Save/delete the records. But I have a problem in the properties / validation for the field.

How can I get the properties [like Data Type (Text, integer, etc.), Field Size, Caption, Format, Validation, Description etc.] of any field of that table in run time of the application?

how can I validate the field?

Can anyone know the solution of this problem?