>To: [log in to unmask]
>From: [log in to unmask] ([log in to unmask])
>Subject: Updating datasets with non-unique keys from VB via ODBC
>
>Up to now I have been told that Microsoft restrictions required all=20
updatable Image/sql datasets to have a  unique key.
>
>After installing Express 3 (MPE-IX 5.3) I discovered by chance that I was=
=20
able to correctly update detail datasets without unique keys from Excel via=
=20
ODBC.
>
>However, when trying to update from a VB application (using VB4.0 16 bit=20
with Data Control) I am not able to make any dynasets updatable.  Are VB4.0=
=20
and Excel using different drivers on the PC ?=20
>
>Should I explicitly open my database instead of using the built-in Data=20
Control ?
>
>If anyone else but me are looking into these matters I sure would like to=
=20
hear from you.
>
Med vennlig hilsen  /  Kind Regards
 
Svein A. L=F8ken
Studierektor  /  Industrial Professor
Regnskap og Revisjon / Accounting and Auduting Group
BI / Norwegian School of Management
Phone: +47 67 57 06 83   Private Phone +47 66 79 75 83
Persons=F8ker / Pager: +47 96 60 59 38
fax +47 67 57 0575