Access level in secured front end and be db

  • Thread starter Thread starter Christer
  • Start date Start date
C

Christer

I have a secured Access db devided in front end and back
end. So I uses 3 files fe.mdb, be.mdb and workgroup.mdw.

I also have 3 kind of users; read only, full data users
and admin.

What kind of access privilege do a user need to network
directory for those 3 files.
Is it possible to give read only users only read
privilege to network directory where my be.mdb is placed?

Thanks!

Christer
 
Christer said:
I have a secured Access db devided in front end and back
end. So I uses 3 files fe.mdb, be.mdb and workgroup.mdw.

I also have 3 kind of users; read only, full data users
and admin.

What kind of access privilege do a user need to network
directory for those 3 files.
Is it possible to give read only users only read
privilege to network directory where my be.mdb is placed?
Click to expand...

No. All users need full permission to the folder, in order to create and
delete the associated ldb files. In addition, you should put the frontend
on each user's computer; you don't want them to share the frontend.
 
Christer said:
I have a secured Access db devided in front end and back
end. So I uses 3 files fe.mdb, be.mdb and workgroup.mdw.

I also have 3 kind of users; read only, full data users
and admin.

What kind of access privilege do a user need to network
directory for those 3 files.
Is it possible to give read only users only read
privilege to network directory where my be.mdb is placed?
Click to expand...

No. When a user opens your app LDB (locking files) need to be created in
the same folders for each of your three files when the first user comes in.
They then need to be modified as other users come and go and need to be
deleted when the last user exits the app. So ALL users need file create,
file modify, and file delete permissions on all of the folders where your
three files will be located.

This does mean that any user can delete any of your files. One of the
downsides of using a file share database unfortunately.
 
Back
Top