By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,630 Members | 1,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,630 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


nico5038
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.

Nic;o)
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!!
kc
Jun 11 '07 #3

nico5038
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 !

Nic;o)
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?

Example:

1/owner/123
1/owner/2354
1/owner/5634

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.