NTFS and MS Access DBs

[TKE402]

Hi,

I have several MS Access DB's that are in a folder that is Read/Execute for
Authenticated users. No one can open the DBs. If I change the permissions to
Read/Write/Execute than it works because the DB lock file needs to be written
to the folder that the DB is located. Is there anyway around this? I do not
want the users to have read,write, execute to that folder. All they need is
read and execute.

Thanks,

TKE402

 

[Lanwench [MVP - Exchange]]

Re: NTFS and MS Access DBs

TKE402 <TKE402@discussions.microsoft.com> wrote:
> Hi,
>
> I have several MS Access DB's that are in a folder that is
> Read/Execute for Authenticated users. No one can open the DBs. If I
> change the permissions to Read/Write/Execute than it works because
> the DB lock file needs to be written to the folder that the DB is
> located. Is there anyway around this? I do not want the users to have
> read,write, execute to that folder. All they need is read and execute.
>
> Thanks,
>
> TKE402

You should probably post this in an Access newsgroup for the most expert
help. I don't know that you can redirect the lock file elsewhere.

 

[David C]

Re: NTFS and MS Access DBs

No way around this. Both mdb and ldb need write capability and you have no
control over placement of lock file as Access creates/deletes it and must be
in same folder as mdb.
HTH.
David
"TKE402" <TKE402@discussions.microsoft.com> wrote in message
news:F8D92C66-1521-4977-8EF8-9651C7F97D39@microsoft.com...
> Hi,
>
> I have several MS Access DB's that are in a folder that is Read/Execute
> for
> Authenticated users. No one can open the DBs. If I change the permissions
> to
> Read/Write/Execute than it works because the DB lock file needs to be
> written
> to the folder that the DB is located. Is there anyway around this? I do
> not
> want the users to have read,write, execute to that folder. All they need
> is
> read and execute.
>
> Thanks,
>
> TKE402
>