473,386 Members | 1,803 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Re-link problem with Access 2007

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
4 2604
MMcCarthy
14,534 Expert Mod 8TB
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
Balex
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
14,534 Expert Mod 8TB
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
Balex
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

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

Similar topics

4
by: Craig Bailey | last post by:
Anyone recommend a good script editor for Mac OS X? Just finished a 4-day PHP class in front of a Windows machine, and liked the editor we used. Don't recall the name, but it gave line numbers as...
10
by: James | last post by:
What is the best method for creating a Web Page that uses both PHP and HTML ? <HTML> BLA BLA BLA BLA BLA
1
by: joost | last post by:
Hello, I'm kind of new to mySQL but more used to Sybase/PHP What is illegal about this query or can i not use combined query's in mySQL? DELETE FROM manufacturers WHERE manufacturers_id ...
2
by: sky2070 | last post by:
i have two file with jobapp.html calling jobapp_action.php <HTML> <!-- jobapp.html --> <BODY> <H1>Phop's Bicycles Job Application</H1> <P>Are you looking for an exciting career in the world of...
1
by: Brian | last post by:
I have an array like this: $events = array( array( '2003-07-01', 'Event Title 1', '1' //ID Number (not unique) ), array( '2003-07-02',
4
by: Zachary Antolak | last post by:
I implemented a timer in my PHP page to see how long it takes to run. Here's the code: $this->start_time = microtime(); /* All the code */ $this->end_time = microtime(); $this->calc_time =...
3
by: Dell Sala | last post by:
I have recently enabled the PHP 4.2.1 that comes pre-installed on OS X. After making all the prescribed changes to the httpd.conf file php seems to work fine. I would like to make some changes...
7
by: Christoph Nothdurfter | last post by:
Hallo! I was wondering if my PHP4-Scripts will run under PHP5 (Haeven't tried the beta yet). Does anybody know? Thank you, -Christoph
2
by: JDJones | last post by:
I'm using the following to generate a random quote on a PHP page and it works fine: <?php $quotes = 'quote #1'; $quotes = 'quote #2'; $quotes = 'quote #3'; $quotes = 'etc...'; srand...
3
by: sky2070 | last post by:
<?php Header("Content-Type: image/png"); $im = ImageCreate(100, 100); // Allocate a background color and a drawing color for the image $black = ImageColorAllocate($im, 0, 0, 0); $white =...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.