MS Access SAN Problem

Hi!

I've encountering a very strange problem. We currently host the back end of an Access application on our server (just a bog standard Win 2003 Server box) and we are looking at moving it over onto our new SAN storage area but we are encountering a problem where the first person to login proceeds to lock out all other users.

Has anyone seen this before/have any advice on this issue?

Thanks in advance.
Lans-ICTAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
Yes. Share permissions are independant of NTFS permissions. The most restrictive will apply.

/gustav
0
 
Jeffrey CoachmanMIS LiasonCommented:
Is the DB location on the Unit set up to act as a standard location:

\\SomeServer\SomeFolder

Do all users have full permissions to this location?
0
 
Gustav BrockCIOCommented:
> Has anyone seen this before/have any advice on this issue?

Yes. It happens when the ldb lock file cannot be created correctly.
Users do not need full permissions to the shared folder but at least create, read, write, delete.

/gustav
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
CarlosDominguezCommented:
Yes. It seems to be a problem with permissions. Just cross-check the permissions in both folders (before and after).
0
 
Lans-ICTAuthor Commented:
Hi guys,

This DB is on a shared folder on a server, the Share Permissions are set correctly but I noted that the NTFS permissions had only the standard (Server\Users Server\Admins etc). Will the NTFS permissions affect this directly?

Andy
0
 
CarlosDominguezCommented:
Yes. It is the reason of the problem. You have to set NTFS permissions correctly. Setting up permission in the "shared" tab is not enough.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.