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

Moved back and front ends - Access 2003

P: 8
I am a beginner - just to give a warning up front :)
I have a split database on one computer. I need to move the whole database, front and back ends to another computer. When I do, it will not allow me to relink the tables easily. Do I have to change the root path so the front can find the back...and how?? Trying to figure this out for, oh, about 3 days now! Thanks in advance...
Jun 10 '07 #1
Share this Question
Share on Google+
5 Replies

Expert 2.5K+
P: 3,072
The easy way is to use the Relink manager under the Tools/Database utilities/Linked table manager menu.
It can be done by code, but this manager does all needed.

Jun 10 '07 #2

P: 8
Okay, this is weird. I tried to use the Relink Tables manager since the get-go 3 days ago. It didn't work. It looked like it was relinking it, but it still didn't actually access the back end. It would turn out that when I would open the front end, it said "C://....databasebackend.mdb is not a valid path."

Then, today, for the heck of it I tried it again. It relinked them just fine. What the heck? Do I have a bug??

Thanks so much for replying, and for giving me the impetus to try it just one more time!!
Jun 11 '07 #3

Expert 2.5K+
P: 3,072
Sometimes Access does have hickups like this.
It could be a faulty networkcard or other divice. Make sure you have all Service Packs installed and when things like this happen an Office re-install could make sure it's caused by an outside reason.

When installing a .mdb on another PC you should always check the references as they can cause havoc too. Open some VBA code (e.g. a module) and see that there's no checked library under the Tools/References starting with "MISSING".

Success !

Jun 11 '07 #4

P: 8
Thank you so much! Got it.
Aug 6 '07 #5

P: 8
Willing to help with one more question???

Have a field "Picture" in a table. I need to change ONE word within the field across all records, but keep all the other info the same. Update query?



Need to change the word "owner" to "me" in the field across all records.

Thanks in advance for the hours you'll save me :)
Aug 6 '07 #6

Post your reply

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