Putting Database on Shared Drive

[tsquared1518]

I have been reading through security and splitting databases, and tried to
accomplish this at work. I almost have it working, but after the other user
signs in, she gets an error that reads;

'C:\users\owner\desktop\DRIInventory-be.mdb' is not a valid path. Make sure
the path name is spelled correctly and that you are connected to the server
on which the file resides.

I have tried copying and pasting the BE onto the server, but it wont change
the path from C to S, which has to be the problem, I think?

Can anyone tell me how to go about fixing this issue?

Thanks for your help!!!

 

[Arvin Meyer [MVP]]

The easiest way I know to get it right is to split the file on the server,
then move the front-end, or better yet a copy to each workstation. That
assumes everyone one has the same drive mappings, and that you are working
from a workstation while you do the splitting. So:

1. Move the file to where it will live on the server
2. Split the file from your workstation
3. Move a copy of the file back to your workstation.

 

[tsquared1518]

Arvin,

I have some time to work on my database again this week. Since I already
split it, am I able to split it again? I tried moving everything from my
desktop to the server. The shortcut path is the same on her computer as it is
mine, but she still cant get it to open. I bought the Microsoft Office Access
2003 Inside Out book, and am currently looking for a solution in it.

 

[tsquared1518]

Nevermind, I was able to get it to work this afternoon. Thanks for your help.