Access 2010: Link manager not working. Other setting changes not saving

I have Access 2010. I am having Issues with link manager to change location of back end not saving the file in new location. It goes through the motions of finding new location and the BE file, The new location window has greyed out icon, but will not save the new location.  Work around was to convert  BE to local tables then resplit to the new location.  

Also, when trying to change display form open options in file/ options/ current database,  none of the changes are being saved and revert to the original settings when I try to test.   This problem seems to be program related as all db files i tested  are having the same issue.  The save function seems to be the heart of the problem as hitting save icon makes the window border flash 3 times but the changes do not take place.  

I have tried compacting the DB.  I went into programs folder  and repaired the program. Rebooted several times and still not being nice. The service packs seem to be for Runtime version.


Johnni IConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
If you create a new database and import objects from the old database does this problem persist?

Are all the back-end files in the same folder?

Are you checking the "always prompt for new location" checkbox when you run the linked table manager?
Armen Stein - Microsoft Access MVP since 2006President, J Street TechnologyCommented:
Hi John,

In order to eliminate the Linked Table Manager from the puzzle, you could try our free J Street Access Relinker on our J Street Downloads page.  It's a lot nicer than the Linked Table Manager anyway.

It's some code that you simply copy into your front-end application.  It handles multiple Access back-end databases, ignores non-Access tables, and can automatically and silently relink to back-end databases in the same folder as the application (handy for work databases or single-user scenarios).  There's a ReadMe table with instructions.

Hope this helps,
Armen Stein, Access MVP
J Street Technology

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.