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

Wrong Primary Key in the linked table

P: 1
I have an issue re primary key upon linking MS access 2000 to Oracle 10g.

I'm going to migrate to a new Oracle server. So I have to re-link the tables to the new server.
I have do the following steps
- create a new ODBC for the new server.
- Use get external data => linked table and then link to the Oracle table via ODBC.
After I link the table to Oracle via ODBC, the primary key on MS linked table is not the same with the primary key on Oracle table.
I have tried to use the Linked Table manager and tick on always prompt for new location. The result is still the same (primary key go to another table).
Could you please advise me how to change the primary key on the linked table or How to force the MS access to ask which PK for the table when I link the tables to Oracle.
Thank you,
Sep 8 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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