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,...