In a message dated 96-01-08 10:46:33 EST, [log in to unmask]
([log in to unmask]) writes:
 
>Up to now I have been told that Microsoft restrictions required all
>updatable Image/sql datasets to have a  unique key.
>
>After installing Express 3 (MPE-IX 5.3) I discovered by chance that I was
>able to correctly update detail datasets without unique keys from Excel via
>ODBC.
>
>However, when trying to update from a VB application (using VB4.0 16 bit
>with Data Control) I am not able to make any dynasets updatable.  Are VB4.0
>and Excel using different drivers on the PC ?
>
>Should I explicitly open my database instead of using the built-in Data
>Control ?
>
>If anyone else but me are looking into these matters I sure would like to
>hear from you.
 
Svein,  I wrote a precis of my findings on this very subject a few months
ago.  In a nutshell, yes you can update a detail dataset linked to an
MSAccess table.  However if you use MSAccess tools, you will be unable to
properly control the update of entries with duplicate key values.  You do not
need to have your dataset linked to an MSAccess table in order to use VB.  I
do not have VB4.0 at the moment, because I did not think you could run VB4.0
through a 16bit ODBC API such as the one supported by HP. (Maybe that is your
problem.)  VB 3.0 runs fine for me directly to the dataset on the HP3000.
 
Kind regards,
 
Denys. . .