Table Security - Access 2000

[SCHNYDES]

Hi all I need some help on Access security.

In the past, I have created databases and used the user level security
wizard to secure and lock down the various parts.

In my new roll, the workgroup cannot be changed due to security measuer on
our CITRIX farm network. However, I have managed to creat a function to call
individual names from their windows logon, let's call it name().

I want to set table/query security based on name(). Name()=John, read and
write access, etc. Is this possible?

 

[Albert D.Kallal]

Assuming you locked down your application, and don't allow uses to direct
see the tables and other parts of the design, then you can certainly do as
you ask.

So, you don't for the most part need security....or in fact ANY code to hide
the ms-access user interface.

So, you should as a general hide all of the ms-access interface. The options
to complete hide and keep people out of the ms-access interface can easily
be done using the tools->start-up options. Using those options allows you to
complete hide the ms-access interface (tool bars, database window etc).
Also, using these options means you do not have to bother setting up
security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

In you case, in the forms on-load event, you simply set the allow edits =
false


if user = readonly then
me.AllowEdits = false
end if

 

[SCHNYDES]

Awesome, learn something new every day. The bypass option was really what I
was looking for...because you're right, I hide all database windows and let
the forms do the talking.

Thanks for the help.

 

[aaron.kempf]

mdb security is a joke

use access data projects with sql server if you care enough to build a
database; build a database that

a) works across a network - mdb doesn't work across any network
b) _CAN_ be secured
c) has job-scheduling capabilities
d) doesn't make you reboot file servers once a week
e) scales past 2 users

 

[aaron.kempf]

no seriously

mdb is for babies and sissies and i hereby challenge every one of you
to an arm-wrestling championship

MDB vs ADP mofo
winner takes all