Mulitple Users can't open an Access database thru a shared folder

[Guest JohnNevener]

We just installed a w2k3 Terminal Server this week and we have Access

databases that live in shared folders, that multiple users need to use daily.

Once an Access database is opened, it creates a lock (.ldb) as is expected.

The problem is, once that lock is created, no other user can even open the

Access db thru their mapped drive to the same share. I checked the share

settings and it IS set to "maximum" users allowed.

 

Anyone have an idea why this is happening?

[Guest rjcmi]

Re: Mulitple Users can't open an Access database thru a shared folder

 

On Nov 9, 5:22 pm, JohnNevener <JohnNeve...@discussions.microsoft.com>

wrote:

> We just installed a w2k3 Terminal Server this week and we have Access

> databases that live in shared folders, that multiple users need to use daily.

> Once an Access database is opened, it creates a lock (.ldb) as is expected.

> The problem is, once that lock is created, no other user can even open the

> Access db thru their mapped drive to the same share. I checked the share

> settings and it IS set to "maximum" users allowed.

>

> Anyone have an idea why this is happening?

 

I admin a .net application which uses Access on a Terminal Server. I

had the same problem at my site, but I was informed by the developer

of the application that each user must have read/write permission on

that folder where the .mdb file resides. Once I did that, everything

worked correctly.

 

I was/still am concerned about the security of that type of permission

for all users, but the developer insisted that was how it was required

to operate.

 

Hope this helps.