Running ms access modules as admin but logged into access as a regular user..

[gangac]

I am currently working on an ms access application for a large insurance
company which generates reports for the user after the user inputs/select
some data....

Unfortunately the application has already been built - and till now we used
to run the application/reports by logging in as admin.. however, we now want
that users login to the database as a 'user' with limited privileges- but
the vba code, which is locked to run with privileges as admin.

Our plan is users sign onto this ms access application/database as a user
with few privilegese on the underlying tables/forms..all the tables and
forms and vba modules are owned by admin....we dont want the user to be able
to view most of the tables but we want the entire vba code to run with the
privleges as admin.. how do we do that.. the user logs on to ms acesss db as
a regular user, with privileges on very few tables/forms.. and the background
vba code which generates the code runs succesfully with privlegse of the
admin user.. is that possible..we want to allow the user to keep this ms
access database/application on any directory they wish on their local pc.

thanks again,
chandran gangadharan
Toronto, Canada

 

[Albert D. Kallal]

Usually security is usually to prevent people from running a particular
reports etc.

You don't need security to run your application and keeps users out of the
code, and forms...

You most certainly can, and should 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

If you distribute a mde with the above, then uses will not even have a copy
of the code, and will be un-able to modify the designs of forms, reports
etc....

It actualy not clear if you really need secirty here at a all.....

 

[gangac via AccessMonster.com]

I do not want the user to view the udnerlying tables either..is that possible.
. thanks,
Chadnran