By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,510 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,510 IT Pros & Developers. It's quick & easy.

Re-link problem with Access 2007

P: 6
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
Mar 12 '07 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Sorry Balex.

This sounds like the memory of the old index is being retained. The only think I can suggest is to run the compact and repair routine after deleting the old link and before importing the new link.

Mary
Mar 12 '07 #2

P: 6
Sorry Balex.

This sounds like the memory of the old index is being retained. The only think I can suggest is to run the compact and repair routine after deleting the old link and before importing the new link.

Mary
Thought about that and did that already. Didn't help, unfortunately. I also stopped the Oracle server and restarted it, but no joy. Also re-booted the PC (one never kows...), but that had no effect either.

Balex
Mar 12 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
OK Next idea.

Open the linked table manager and refresh all links. If that doesn't work try just ticking the new link and tick the always prompt for new location box.

Mary
Mar 12 '07 #4

P: 6
OK Next idea.

Open the linked table manager and refresh all links. If that doesn't work try just ticking the new link and tick the always prompt for new location box.

Mary
I tried the link manager as well (for that one table), but I did not see the "always prompt for new location box", so that's definitively something to try !

Thanks a lot
Mar 12 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.