Securing my forms in my database.

[Guest]

My database opens a menu which has buttons leading to two other menus. one of
these menus is for everyone to use, the other is only for the administrator
as it contains additonal functions that i do not want everyone to access. is
it possible to put some kind of user access on so only the administrator can
access the administrators menu?

i have been able to do it using the user and group accounts but that
security only relates to the computer that i setup that security on. if i
take the database to another computer the user logon doesn't appear. the
security needs to be built into the program itself.

any help would be appreciated.

Thanks

 

[Joseph Meehan]

My database opens a menu which has buttons leading to two other
menus. one of these menus is for everyone to use, the other is only
for the administrator as it contains additonal functions that i do
not want everyone to access. is it possible to put some kind of user
access on so only the administrator can access the administrators
menu?

i have been able to do it using the user and group accounts but that
security only relates to the computer that i setup that security on.
if i take the database to another computer the user logon doesn't
appear. the security needs to be built into the program itself.

any help would be appreciated.

Thanks

I am assuming that this is a shared database? That is it is located on
a LAN and everyone is accessing the same database.

If so I suggest you split the database. Only the data should be stored
on the LAN (this is called the back end database). That is Tables
containing data that will change. Forms reports, queries etc. should be on
the front end databases on each individual's machine.

There are a number of reasons for doing this, but it does work a lot
better than having just one file and it works faster with less corruption
issues.

Once split, all you need do is supply front ends to the users with just
the forms you want them to have access to. Different front ends for
different users.

Of course there is still the easy work-a-round of just accessing the
same back end data with a front end of their own making, unless you secure
the back end.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.