How to change the path of DoCmd.OpenForm

I am working on a Access DB that I had to copy from one location to another so that I could work on it with out touching the original.  This is a DB that I have inherited and it has been a very long time since I have worked with vb and Access.

So every time I click a button I am getting the wrong path error to open up a different form. I have  looked at the code and  I am not able to see how to change the path to match the new path that I have for the test Access folder.

How would I go about making that change?

thanks
Richard ComitoDirector of ITAsked:
Who is Participating?
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.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:

Sounds like you need to relink tables to the back end at a new location.
In the database window, click on the Tables tab.
Right click over the window and select Linked Table Manager.

Check the box 'Always prompt for new location.

Then Select All, then Browser to the new location ... select the back end mdb ... and finish the relinking.

mx
0

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
Bill RossProgrammerCommented:
Please post a screen shot of the error and the code that does  not work.  Alos, to verify that you are connected to data open the table that is bound to the form.  If there is no data your form will not display.  You must then relink per DatabaseMX instructions above.
0
Richard ComitoDirector of ITAuthor Commented:
DatabaseMX,

Thanks.

Gabicus
0
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.