B
Balex
Hi
I have recently helped somebody converting an Access application into an
Access (2002) front-end and an Oracle backend. It worked fine, until he
decided to install and use Access 2007 instead of Access 2002. Just while he
was changing Access version, I had to make one structural change in one table
in the Oracle DB. No sweat, I thought, just delete the link and link again.
This works perfectly well with Access 2002.
However, with Access 2007, the OLD table definition is coming through again
partially, no matter what I do. What I changed in that table in Oracle was
adding a field and making that new field the primary key. Now there is NO WAY
that Access 2007 will take this new field as PK when re-linking !!! It
INSISTS in keeping the PREVIOUS definition of the PK of that table, which was
another field ! Even when I remove the PK entirely in Oracle and re-link
again, Access 2007 does NOT ask for which field is the PK and uses the old
field as a PK !
Any idea how I can get rid of that "phantom" definition ?
Thanks for any hints...
Balex
I have recently helped somebody converting an Access application into an
Access (2002) front-end and an Oracle backend. It worked fine, until he
decided to install and use Access 2007 instead of Access 2002. Just while he
was changing Access version, I had to make one structural change in one table
in the Oracle DB. No sweat, I thought, just delete the link and link again.
This works perfectly well with Access 2002.
However, with Access 2007, the OLD table definition is coming through again
partially, no matter what I do. What I changed in that table in Oracle was
adding a field and making that new field the primary key. Now there is NO WAY
that Access 2007 will take this new field as PK when re-linking !!! It
INSISTS in keeping the PREVIOUS definition of the PK of that table, which was
another field ! Even when I remove the PK entirely in Oracle and re-link
again, Access 2007 does NOT ask for which field is the PK and uses the old
field as a PK !
Any idea how I can get rid of that "phantom" definition ?
Thanks for any hints...
Balex