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

  • Thread starter Thread starter JohnNevener
  • Start date Start date
J

JohnNevener

Guest
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?
 
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.
 
Back
Top