Folder Permission for BE

[Guest]

Hi all,

Have a question I can't seem to find the answer to.

I have a FE/BE database and everything works fine currently. I want to move
the BE into a folder where the only permissions are Read/Read & Execute/List
Folder Contents. The DB admin (me) is the only one with Write permission.

When users use the MDE file to access the DB, I get an error saying the file
is already open. But it's not open at all (I know this for a fact). The
error only occurs when I move everything to the folder with new permissions.
Previouly we had everything in a folder with full control and the FE/BE
interacted without errors.

The users are not editing the data in the BE in any way. They are only
performing searches. If there a way to allow the FE access to the DB without
allowing write access to the BE?

This is the first time I've dabbled in the security aspect of Access and I'm
not sure what to do. Do I need to change permissions in the DB itself?

Any help is appreciated. I'm using Access 97.

Thanks,
Jay

 

[TC]

You can't use normal Windows folder permissions to establish access
levels within an Access database.

When you open a database (FE, BE or otherwise), Access creates a
locking file (LDB extension) for various purposes. It reads & writes
that file during operation of the database. When the last user quits
Access, it then deletes that file. So, normally, each windows user must
have full read/write/update/delete access to the folder(s) in which the
database(s) reside.

You can maybe avoid that behaviour by starting Access with the /excl
and/or /ro switches. These should be in online help. Alternatively, you
could establish Access User Level Security (ULS) to set the permissions
you want. ULS is a large topic, you'd need to devote several weeks
(perhaps more) to understanding it properly & being able to use it
effectively.

HTH,
TC

If all you

 

[Guest]

Alright, thanks for the response. I was worried that might be the case.

Jay