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

Back end file path not found

patjones
Expert 100+
P: 931
Good morning all:

I have an Access database that I recently made some improvements to and committed back to the network drive in my office for everyone to use. One of those improvements was to split it into a front end and back end.

It works fine on most computers, but there are two or three that, when my co-workers try to open it, Access tells them that the path to the back end file is invalid.

I tried compacting and repairing both the front and back ends, putting them both in the same folder, deleting and copying them back to their respective locations (all pretty desperate moves, I know) - but no results.

Someone posted a similar problem earlier in the year, but no one responded. So here is your second chance to respond, experts!

Thanks!

Pat
Dec 12 '07 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,396
Have you tried relinking the tables?
Dec 12 '07 #2

NeoPa
Expert Mod 15k+
P: 31,661
Let me know if the info in Need to use full path to linked tables helps you to resolve this.
I'm fairly sure that the problem is related to the path not being "valid" on some machines but valid on others.
Dec 12 '07 #3

patjones
Expert 100+
P: 931
Let me know if the info in Need to use full path to linked tables helps you to resolve this.
I'm fairly sure that the problem is related to the path not being "valid" on some machines but valid on others.
Well, one of our network people took a look at the situation and did something that corrected the problem before I could try anything in your link. I still don't know yet what her solution was, but I will find out tomorrow and keep everyone posted!
Dec 13 '07 #4

NeoPa
Expert Mod 15k+
P: 31,661
If it was a network person I guess they probably made the share available to all the other PCs on the same drive letter. Let us know anyway.
Dec 13 '07 #5

patjones
Expert 100+
P: 931
If it was a network person I guess they probably made the share available to all the other PCs on the same drive letter. Let us know anyway.
In a manner of speaking, I think that's correct. I just got off the phone with them. What they had me do was open up the development copy of the front end on my computer, right click on one of the linked table, and open up Linked Table Manager. I then selected all the tables, checkmarked "Always prompt for new location", and hit OK.

In the resulting dialog box they had me type in some obscure path that I wasn't aware of. Apparently, now whenever I commit a new version of my front end to the network drive, it will always point to the proper place.

Anyhow, it fixed the problem! Thanks so much for responding...

Pat
Dec 13 '07 #6

NeoPa
Expert Mod 15k+
P: 31,661
No problem Pat.
Actually, from your last post it sounds as if she knew about how Access works too and had you use a UNC path (I would guess) to the share rather than using a drive letter at all.
That's cool - That's exactly what I would have suggested 8-)
Dec 13 '07 #7

Post your reply

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