I have a new database that I am trying to figure out the best way to secure.
This database will collect input from an ASP web form that feeds into one
specific table in the database.  The problem is that I do not want any body
besides the Admins group to be able to see the data ...

I writing my code that will enable/disable controls based on the user groups.
What I am finding is that when I set my code for one particular groups it
affects the other groups.  So my question is,  will I have to use the If
faq_IsUserInGroup statement for all of my groups?

I am testing the Office 2007 Beta and I am pleased with a lot of the new
features. However one feature is really bugging me. It is the Security Alert
in Access.
Why does it keep asking me if I want to enable contents and then it asks

This is going to be my first time adding security features for my
database.
I want to give access to my database to my boss and his boss. But I
also want other people to look up stuff if they need to. Like look at

I have Microsoft Office XP 2002.  When I first loaded Office, I
installed all of its components, but until recently never had a use
for Access.  I was recently diagnosed with Diabetes and along with my
tester, I purchased specialty software for tracking my Diabetes.  Some

after many nightmare about getting rid of Access security warnings popping
up on computers of few members of our staff (all of them will use the runtime
version of Access) that use an application developed with Access 2003 and
deployed with the Package Wizard provided with the ...

Scenario.
I initially created a switchboard using Switchboard, but based on previous
advise, I created two forms instead ; Manufacturing and Regulatory.  These
forms are based on two groups that were created in Access security tool.  

What is the proper Syntax for using the
IsUserInGroup Function in a Form's Open Event  Here is my current Syntax but
I am getting the following
error message: Expected End Sub

I setup security groups and users for a particular DB, now when I open
any DB it requires that I login. I did not intend for that, and it will
be a problem for other users with limited privileges. How can I use
security for just a single DB rather than all DBs?

on saving a access program i went into startup and got rid of all access to
menu bars qnd toolbaes , but now i can not get them to come back again in
this program
   can you help please !

After a day of struggling with it, I finally created a new workgroup with
myself as the administrator of a user-level secured DB, with others having
limited permissions.  
I tested the security by logging onto the DB as one of the limited

Is there a way to restrict users from clicking on a command button on the
main switchboard.    
Scenario:
I have created two groups, manufacturing and regulatory.

I'm used to Access 97 security, so with 2003 I created a work group file and
a blank database, logged on with MyID and created a new database, which
opened immediately.  MyID was the database owner until I logged out.  When I
logged on again the default 'Admin' user was now the ...

I'm trying to run a crystal report from an access database.
When trying to select any table from this database as the data source I get
the error:
Query Engine Error:  'DAO Error Code: 0xC26 Source:  DAO.Fields

I have a search form that has one text box that is input procedure into a
query.
using query expression :
Like "* " & [Forms]![test]![keywordsearch] & "*"