Cannot access Ms-access database on a network drive via terminal

[Blank]

Hi

I'm having a problem using access on a mapped network drive on a terminal
server.

Only the administrator account ( and not group) can run the databases, all
others get an error message telling that windows cannot access the
drive/path/file cause the user don't have the permission. But in fact they
have it all the way. Running access locally on the ts works like a charm. All
other office apps does not encounters any problem.

Only access applications able to run are application that are splitted from
the table, in this case access say that they only have read rights ( so the
network part can be read but not execute)

any help welcome.

 

[Arvin Meyer [MVP]]

If you don't want to corrupt your database irreparably, follow these
instructions:

1. Split the database into front-ends with everything but the tables, and a
back-end with the tables.

2. Link the front-end to the back-end.

3. Create a folder for each user on the Terminal Server.

4. Make sure that each user has a copy of the front-end in their folder.

5. Using server security, make sure that no one except the administrator has
access to anyone's folder but their own.

Any other method on a Terminal Server WILL eventually corrupt the files,
will corresponding data loss. Using the method above, everything will be
stable and work for years without problems.

 

[Blank]

Most of my database works that way already

my prob is any account on the ts wont be able to modify it cause the server
is sending a « you don't have the right to access these files » but the
permission are well set.

this is pretty weird in my opinion, only the administrator account work
properly, still not working with users in the administrators group.

thx for the reply

best

-B

 

[Arvin Meyer [MVP]]

It is still probably a permissions problem. Every user needs all permissions
except Full Control.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com