Help ! Link problem with Access 2007

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top