How to know if the user is READ only?

  • Thread starter Thread starter Jonas
  • Start date Start date
J

Jonas

I have a database with multiple users. Some of them are poweruser
(read/write on disk F:\) and other are "read only".

Is there a way I can know if the user can write data in my database?

When I'll know the king of user, I can redirect the "READ only user" to a
basic Form with minimum information.

-I want a VB code with this thinking:

If my user is a poweruser then

open this switchboard

else

open frmBasicInformation


-Aternate logic

If the actual user can create a folder then

it's a poweruser (direct some place)

else

you are a guest (redirect elsewhere)


Thanks in advance.

Vous pouvez me répondre en français aussi ! :-)


Jonas
 
Hi Jonas,

You'll know, because any users with read-only access to the folder will be
unable to use the database, so they'll complain ;-)

All users need full permissions on the folder where the database is, so that
the .ldb file (the "lock" file) can be created/amended/deleted as they
enter/use/leave the database.

If you need additional control, you can either:

1. use Access User Level Security - this has a steep learning curve, and
you must get everything right.

or

2. implement your own user-level system - but it won't be at all secure;
any knowedgable user will have no problem by-passing it.

Rob
 
Le 09 juin 2008, Rob Parker nous a si bien dit:
Hi Jonas,

You'll know, because any users with read-only access to the folder
will be unable to use the database, so they'll complain ;-)
Click to expand...

I agree, I didn't think about that.. :-0
All users need full permissions on the folder where the database is,
so that the .ldb file (the "lock" file) can be created/amended/deleted
as they enter/use/leave the database.
Click to expand...

Finally, I've created a Report in the same folder with all the form details
to let my "read only" users something to read..

Thanks again, and have a nice day !

Jonas
 
Back
Top