Error message when accessing the b_e

[browninaz]

Hello everyone,

I am having a bit of a problem with sharing the back end of my database on my company network. I have split my database and assigned copies of the front end to 3 other nodes while keeping the back end on a public drive. This has worked fine and dandy up until I added a new node to the network. I moved the master copies of the front and back end to the new node which serves as a quasi-server, re-split my database to link the f_e tables to the tables in the new drive, and when a any user other than the user on the quasi-server opens their copy of the front end and tries to access data via a button, an error message pops up that says:

'C\Users\Public Documents\Database\THT.b_e.accdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

On my network there are four nodes connected by a home network, and all the drives are shared to read/edit/modify.

I have tried splitting the db several times with a new name, putting the b_e on different drives, and nothing seems to work so far. I have checked and double checked to make sure the drives are shared, and still nothing :banghead:I have a feeling that it is something trivial that I'm not seeing, so hopefully someone out there has a simple solution for this database novice.

Thanks to all in advance

 

[JHB]

I don't know if the "." can cause this!

'C\Users\Public Documents\Database\THT.b_e.accdb

 

[ypma]

I don't profess to have an answer but, It seem that the path is at fault . Try creating a short cut of the back-end , to one the desktop of a PC giving you the error ,and then check the properties of the short cut and you will be able to confirm if the path is the same as yours . Also have you tested the links using the link manager on the users Pc that do not connect ?
Hope this is of some use to you
Regards

 

[jkl0]

It looks like the problem may be that it is looking at the "C" drive instead of the network name of the server.

YourUNCPath\Users\Public Documents\Database\THT.b_e.accdb

 

[browninaz]

Hey everyone,

Sorry it took so long to post, but the problem was solved the other day. I just used the linked table manager to refresh the path to the b_e and the f_e was then able to find the tables on the new drive.

Thank you to all who had valuable input. I really appreciate it.