Linked table manager looking for old table name

[diberlee]

Hi all,

Having a wee issue that I hope is simple for somebody more experienced with this Access monster...

I have a database that is used in our office. It is split with the backend stored on a network share.

I need to make some updates, and to do maintenance I usually make a copy of the frontend/backend to my desktop, and use the linked table manager to switch to using the local copy of the backend so I don't mess up the main data. All good so far.

however, I recently added a new table, and originally called it "overRides", I then decided that "adjustments" was a more suitable name and changed it.

Now whenever I try to switch from the main backend to my local copy I get a message when relinking "adjustments" that Access cannot find the object "overRides" and to make sure it exists and the name is spelled correctly...

I have been just deleting the linked table and reimporting "adjustments" but this issue keeps coming back and it's driving me nuts! :banghead:

How can I make Access forget that this table used to be called "overRides"?

Regards
Duane

 

[CJ_London]

do you have any queries or vba code referring to overRides?

 

[diberlee]

No, nothing refers to it at all.

I just set up the table and insert records to it from an excel sheet. I'm capturing some data about changes made to the sheet but not reporting on them just yet.

I turned off name auto correct in both front/back end but still no joy.

 

[MS$DesignersRCretins]

Try renaming the local from adjustments to overrides, then rename from overrides to adjustments, all with name correct ON.

If it's just the linker, not the linkee, delete and recreate the link.

No guarantees, but this type of approach, perhaps with a tweak or two that I don't recall, has made it "forget" for me. I sympathize, since I believe you are really blameless here.

 

[CJ_London]

try deleting the table link, then compact the db then create a new linked table

 

[diberlee]

Thanks for the suggestions guys. I'm away from work until Monday but I'll give them a go when I'm back and post back here.

Cheers

 

[diberlee]

I tried CJ's approach first and that seems to have worked. I removed the link, did compact and repair on both sides of the database and re-linked.

I used the linked table manager to switch from my desktop copy, to the live data and back again without any shenanigans. Thanks again to both of you.