split db question

[Guest]

I split my database and put the backend mdb on W:\Inventory\Database. I
placed the front end mde in C:\Inventory Control. I can access the front
end fine (I have admin rights) but the other users on the computer can not.
It says it can not find <objectname>.mde. However if I move the front end
to any network drive, all users can access it fine. Any ideas would be
great. I have tried giving special permissons in the security tab to that
mde but it does not make a difference. I am about ready to put the whole
unsplit database back on the network. Thanks in advance.

Pete

 

[Joseph Meehan]

I split my database and put the backend mdb on W:\Inventory\Database.
I placed the front end mde in C:\Inventory Control. I can access
the front end fine (I have admin rights) but the other users on the
computer can not. It says it can not find <objectname>.mde. However
if I move the front end to any network drive, all users can access it
fine. Any ideas would be great. I have tried giving special
permissons in the security tab to that mde but it does not make a
difference. I am about ready to put the whole unsplit database back
on the network. Thanks in advance.

Pete

Each user should have their own copy of the FE. All the time consuming
stuff occurs on their own machine so it does not slow up access by other
users.

Just give each user a copy of the FE.

If you have problems or if you will be regularly updating the FE, there
are several schemes to handle that.

 

[Joseph Meehan]

Each user should have their own copy of the FE. All the time
consuming stuff occurs on their own machine so it does not slow up
access by other users.

Just give each user a copy of the FE.

If you have problems or if you will be regularly updating the FE,
there are several schemes to handle that.

I just reread your message and I can see how I may have miss-understood
what your situation was. Are all the users using the same PC?

Is the mde that is not being found the FE or the BE? If the FE is on
their own computer and you are getting that message, I would guess the icon
they are using is not pointing to the correct directory.

 

[Guest]

Yes all the users are on the same PC. The mde is the front end that can not
be found. To further explain the issue, the first and only the first user
that logs on the computer can access the file, then to make it more confusing
the next time that user logs on it is says it can not find the mde. Even if
they go to the file in Windows explorer and open it, it says opens Access and
says the file cannot be found. Thanks for any help and ideas you my have.
Not much help from my IT dept so I it is up to me to figure this out. Thanks
again

 

[Joseph Meehan]

Yes all the users are on the same PC. The mde is the front end that
can not be found. To further explain the issue, the first and only
the first user that logs on the computer can access the file, then to
make it more confusing the next time that user logs on it is says it
can not find the mde. Even if they go to the file in Windows
explorer and open it, it says opens Access and says the file cannot
be found. Thanks for any help and ideas you my have. Not much help
from my IT dept so I it is up to me to figure this out. Thanks again

When they log in under their own ID I suspect you will find that the
path "W:\Inventory\Database" is not mapped for them.

 

[Guest]

W is a public drive available to all users and guest, in fact if I move the
mde to any other drive, the mde will work fine (meaning the mbd-be is still
in W:\Inventory\Database). Does that help any.

 

[Joseph Meehan]

W is a public drive available to all users and guest, in fact if I
move the mde to any other drive, the mde will work fine (meaning the
mbd-be is still in W:\Inventory\Database). Does that help any.

Sorry I am out of ideas. You may want to double check that the W: drive
ends up exactly the same place for all users. See if you can find the mde
file using the standard Windows file finder with the other users logged on.