S
steph
Hello,
I have an access file which holds a form displaying the contents of a
linked table for editing. The linked table resides in an Oracle 10
database and is accessed via Oracle's ODBC-driver.
This form has no logic, apart from setting creation-date and
creation-user before update/insert.
What happens is, that whenever changing data on the table I got an
Oracle Error from ODBC 'connection lost'. Eventually I figured out,
that by relinking the table and using an extended set of primary key
candidates it did work again.
But it worked only on my PC! When one of our users tried it on his PC
all of the data-grid's fields where displaying '#deleted' - but this
was the same mdb-file! Ok, so i called linked-table-manager and
refreshed the table link, which made the data visible again - but only
displaying the data worked, not updating them.
Finally I relinked the table again, setting the primary key to what
I've had before, and now this form works on both PCs (Hopefully on all,
but I'm not at all sure about this!). Now I have the same version
working, that lost the ODBC-connection in the beginning.
The version of access is the same on all PCs (2002 - 10.2627.2625), the
odbc driver is the same, I'm connecting to the same database server.
And also the version of windows is the same. This horrifies me, because
how can I develop sane forms, when I can't rely on the same behaviour
on each and every pc?
Thanks for any input!
Stephan
I have an access file which holds a form displaying the contents of a
linked table for editing. The linked table resides in an Oracle 10
database and is accessed via Oracle's ODBC-driver.
This form has no logic, apart from setting creation-date and
creation-user before update/insert.
What happens is, that whenever changing data on the table I got an
Oracle Error from ODBC 'connection lost'. Eventually I figured out,
that by relinking the table and using an extended set of primary key
candidates it did work again.
But it worked only on my PC! When one of our users tried it on his PC
all of the data-grid's fields where displaying '#deleted' - but this
was the same mdb-file! Ok, so i called linked-table-manager and
refreshed the table link, which made the data visible again - but only
displaying the data worked, not updating them.
Finally I relinked the table again, setting the primary key to what
I've had before, and now this form works on both PCs (Hopefully on all,
but I'm not at all sure about this!). Now I have the same version
working, that lost the ODBC-connection in the beginning.
The version of access is the same on all PCs (2002 - 10.2627.2625), the
odbc driver is the same, I'm connecting to the same database server.
And also the version of windows is the same. This horrifies me, because
how can I develop sane forms, when I can't rely on the same behaviour
on each and every pc?
Thanks for any input!
Stephan