Here are the steps to accomplish this, it is assumed:
ODBC DataServer license is installed on the machine where MS Access Database is installed and the schema holder is going to be created on this machine, no DataServer broker is required.
1. Create an ODBC DSN under Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN.
USE Microsoft Access Driver (*.mdb) ODBC Driver.
2. Test the ODBC DSN to verify that the connection is working by using any SQL tool or MS Excel.
3. Create a Progress empty database (schema holder) with any identifiable name, and connect to it in single user mode.
4. From the "Data Administration" window, go to DataServer > ODBC Utilities > Create DataServer Schema...
5. Supply "Logical Database Name". This also could be any identifiable name but not the same as the schema holder name).
6. If the access Database does not have any user security, the connection parameter will not require any -U <user_name> and -P <password> parameters.
7. Enter the name of the ODBC DSN name that was created in step 2, and click OK.
8. Click OK on the next screen without entering the user name and the password. If you supply -U and -P in the step 6, this screen will not require any input.
9. In the "Pre-Selection Criteria For Schema Pull", either leave stars in all of the input text box, or enter the appropriate name for any one of the criteria. If all the tables is required to pull into the schema holder, only the owner name is required.
10. Use a single mouse click to choose a table or another single mouse click to select a table or use "Select Some..." and "Deselect Some..." buttons to select and deselect the table(s).
11. Click OK and it should bring all the selected tables' references to the schema holder.
12. After schema holde is created, use following connction parameters to connect to schema holder and MS Access database
prowin32 odbholder -RO -db dsn_demo -dt ODBC -ld demo -H host1 -S oserviceA -U bob -P bobpass
odbholder - schema holder name
dsn_demo - ODBC DSN name
demo - logical name