Hi there,
I have created an ODBC Dataserver schema to read records from a MS Access database.
I use the create <table> command in progress to create records. However i have encountered a number of probs using this method.
1) The Autonumber is not incremented in Access, i need to input a number.
2) It seems all values get set to '?'. When assigning '?' to logical fields, i get error messages: <field> is mandatory but has an unknown value (?).
I have checked the table in the access db, these fields are not marked as mandatory.
Does anybody have any ideas how to overcome these probs?
Winnt 4.0. Progress 9.1d.
I have created an ODBC Dataserver schema to read records from a MS Access database.
I use the create <table> command in progress to create records. However i have encountered a number of probs using this method.
1) The Autonumber is not incremented in Access, i need to input a number.
2) It seems all values get set to '?'. When assigning '?' to logical fields, i get error messages: <field> is mandatory but has an unknown value (?).
I have checked the table in the access db, these fields are not marked as mandatory.
Does anybody have any ideas how to overcome these probs?
Winnt 4.0. Progress 9.1d.