Dear Listeners,

My task is to develop an application in VB6 accessing an IMAGE SQL -
Database using ODBCLink/SE-32 Driver.

I 've got big Problems in updating inserting and deleting data on the HPE
3000 in special cases.

e.g. there are three tables:

Name: driver,manual(1/2)
Entry: keydriver(1) 9(2)
 name  9(16)

Name: car,manual(1/2)
Entry: keycar(1) 9(2)
 lkwbez  9(16)

Name: tour,detail(1/2)
Entry: keycar(!car) 9(2)
 keytour  9(2)
 keydriver(driver) 9(2)
 kilometer 9(7)

Accessing the tables driver and car causes no problem e.g. using the visual
data manager of VB6,
the front end is created automatically and works fine !!!

Creating the front end tour works fine, too (I can see and scroll through
all data).

Updating, deleteing, ... works fine in driver and car.

Doing the same with tour I get the error message runtime error
3027actualizing not possible
database or object is write-protected.

Using MS Access97 I am asked for an unique key / identyfier for tour. If I
press the cancel button
I have no rights in updating inserting and deleting data.
If I choose which field however as primary / unique key I get all rights I
need, so MS Access97 creates or what ever
a faked or correct identifier...

... so I have to define an unique key of a record in an IMAGE detail
dataset in order to perform an update
 via ODBCLink/SE (given that ODBCLink/SE requires an unique key to access
IMAGE via IMAGE/SQL)

How can I do this with my VB application ?????


Thanks in advance


Andreas Schürmann
[log in to unmask]