NTFS and MS Access DBs

[Guest 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

[Guest 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.

[Guest 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

>